Salil Salil - 1 month ago 5
MySQL Question

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

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

Answer

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.