select distinct left(title,2) as fl
                from lect_url
                where title like '%'
                order by fl asc
Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb3_general_ci,COERCIBLE) for operation 'like'


select SQL_CALC_FOUND_ROWS id,title
                from lect_url
                where title like '%'
                order by title asc
                limit 0, 100
Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb3_general_ci,COERCIBLE) for operation 'like'

Читанка