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

Question

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

user_219992 · 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.

user_226834 · Answer

Try this:

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

user_1579374 · Answer

One can also use RLIKE as below

SELECT * FROM artists WHERE name RLIKE '^[abc]';

user_7014633 · Answer

I would go for substr() functionality in MySql.

Basically, this function takes account of three parameters i.e. substr(str,pos,len)

http://www.w3resource.com/mysql/string-functions/mysql-substr-function.php

SELECT * FROM artists 
WHERE lower(substr(name,1,1)) in ('a','b','c');

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

7 Answers