How do I search for names starting wih A in MySQL?

Question

hi, I have a question that how can we use SELECT for searching the name which start with 'A' in MySQL table? thanks

Answer 1

MySQL docs

... LIKE 'A%'

(the first part of the query should be easy for you)

Answer 2

Using the LIKE operator, e.g.:

SELECT lastName FROM yourTable WHERE lastName LIKE 'A%'

Answer 3

SELECT name FROM <tablename> WHERE name like "A%"

Answer 4

You use the LIKE command. The % is a wildcard.

SELECT * FROM table WHERE column like 'A%';

Answer 5

SELECT * FROM table_name WHERE columnname LIKE 'A%'

Answer 6

http://www.w3schools.com/SQl/sql_wildcards.asp

SELECT * FROM Persons
WHERE Name LIKE 'A%'