Salil Salil - 1 year ago 80
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 Source

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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download