How to search for names starting with A in MySQL?

Question

My question is, how can we use SELECT to find a name that starts with "A" in a MySQL table? thank

Answer 1

SELECT * FROM table_name WHERE columnname LIKE 'A%'

Answer 2

MySQL Docs

... LIKE 'A%'

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

Answer 3

LIKE, :

SELECT lastName FROM yourTable WHERE lastName LIKE 'A%'

Answer 4

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

Answer 5

LIKE. % .

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

Answer 6

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

SELECT * FROM Persons
WHERE Name LIKE 'A%'