how to Select string starting with lower

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

how to Select string starting with lower

Post by mister_v »

Hi,

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

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

Re: how to Select string starting with lower

Post by chris »

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