how to Select string starting with lower

Post Reply
mister_v
Posts: 158
Joined: Thu Mar 04, 2010 9:19 pm

how to Select string starting with lower

Post by mister_v » Thu Nov 01, 2018 12:24 pm

Hi,

How do I create a select-query that only selects strings starting with lower characters ?

thanks

chris
Site Admin
Posts: 162
Joined: Mon Jul 21, 2008 9:52 am

Re: how to Select string starting with lower

Post by chris » Thu Nov 01, 2018 12:31 pm

In mysql I like to use :

Code: Select all

SELECT name FROM table WHERE BINARY(name) REGEXP '^[a-z]';
It work really well for me.

Post Reply