select field starting with char

ironCode · #1 (**permalink**) 10-26-06, 17:07

Ok because this forums search sucks (google should stay on google.com) i can't find anything with the search. I'm sure this is extremely easy.

What i'm trying to do is select all data (rows) that starts with a particular character.

For example i have the following table

id | data
1 | abc
2 | bcd
3 | zkb
4 | aht

now i need to pull all the fields containing the letter a (or A) as the first letter of the first word. I know how to do this in php but can't find anything for mysql. I believe i could user a wildcard char (%) in there but would that be the best way? it seems like that would put additional load on the server that isn't needed.

Any help would be great

r937 · #2 (**permalink**) 10-26-06, 19:36

Code:

select ...
  from ...
 where left(data,1) = 'a'

Internet Services

Web Development

Digital Marketing

Consumer Tech