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

Question

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

Accepted Answer

```
SELECT * FROM table_name WHERE columnname LIKE 'A%'
```

Solution