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

Question

Hi All,

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

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

But not GlAin, doC, dolBie

Regards,

Salil Gaikwad

Answer 1

Try this:

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

Answer 2

You can use like 'A%' expression, but if you want this query to run fast for large tables I'd recommend you to put number of first button into separate field with tiny int type.