Painting Blue Code
Simple, self-explanatory code snippets.
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment