where clause first letter?

[karimali831]

Hi,

 

I am using while loop to fetch rows of users and want to add an A - Z search, if the user clicks "S" for example it should return

all results where the first letter of string (whether upper case or not) is equal to "S" or "s". Can I do this with WHERE clause?

 

Thanks anyone.

[melloorr]

Hi,

 

I am using while loop to fetch rows of users and want to add an A - Z search, if the user clicks "S" for example it should return

all results where the first letter of string (whether upper case or not) is equal to "S" or "s". Can I do this with WHERE clause?

 

Thanks anyone.

 

WHERE whatever LIKE 's%'

[karimali831]

Thanks very much!! Brilliantly simple

[karimali831]

I have other question, want to do something simular - WHERE first letter is non-alphabet?

So it can be anything such as WHERE =  |?><!£$%^& etc

[karimali831]

bump

[PFMaBiSmAd]

WHERE your_column REGEXP '^[^a-zA-Z]'

[dreamwest]

WHERE `column` REGEXP  '^[0-9]'