how to Select string starting with lower

[mister_v]

Hi,

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

thanks

[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.