↓
―
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'