2015-08-03

MySQL - Filter for rows with values starting with a lowercase letter

select *
from TABLE_NAME
where CONVERT( FIELD_NAME USING latin1) COLLATE latin1_general_cs regexp '^[a-z]'
;

No comments:

Post a Comment