MySQL: Check if first character is _not_ A-Z
Posted
by dbemerlin
on Stack Overflow
See other posts from Stack Overflow
or by dbemerlin
Published on 2010-03-19T13:20:59Z
Indexed on
2010/03/19
14:01 UTC
Read the original article
Hit count: 225
mysql
|mysql-query
I have to create an SQL Query to get all rows starting with a specific character, except if the parameter passed to the (PHP) function is 0, in that case it should get every row that does not start with A - Z (like #0-9.,$ etc).
What is the easiest and fastest way to get those rows?
DB: MySQL 5.1
Column: title
© Stack Overflow or respective owner