mysql query A-Z
Posted 18 July 2006 - 12:10 AM
I'm trying to do query that matches the first character of a feild. Rather than selecting all rows from the table then doing an 'if' statement to filter out the rows you dont wont, is there a way doing a mysql query that only matches the first character?
Posted 18 July 2006 - 12:47 AM
Posted 18 July 2006 - 01:29 AM
Thanks mate, works great. I guess its not case sensitive?
Correct. Did it need to be? If so, I *think* you need to modify the query to ... BINARY left(somefieldname,1) = 'your choice of case-sensitive letter'
Posted 18 July 2006 - 08:01 AM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users