Webmaster2020.com

Posted: **Thu Nov 01, 2018 12:24 pm**

Hi,

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

thanks

Posted: **Thu Nov 01, 2018 12:31 pm**

In mysql I like to use :

SELECT name FROM table WHERE BINARY(name) REGEXP '^[a-z]';

It work really well for me.

how to Select string starting with lower