find all the name using mysql query which start with the letter 'a'

Asked 2009-12-23T08:06:00.963

I want to find the data from table artists where name is start with letter a, b, c.

i.e. 
My o/p should contain
Adam
Alan
Bob
Ben
Chris
Cameron

But not GlAin, doC, dolBie

mysql

Edit Report

1 Answer

Try this:

select * from artists where name like "A%" or name like "B%" or name like "C%"

answered 2009-12-23T08:08:43.613