MySQL query LIKE getting error

Question

I want to search for people whose name start with letter A using LIKE query but I'm getting errors. What query should I type in order to get results based on people whose name start with a particular letter or not with that letter?

What is the error? What is the query you are trying?

Hurricane Development
– Hurricane Development

2016-08-26 19:52:46 +00:00
Commented Aug 26, 2016 at 19:52 — Hurricane Development
– Hurricane Development, Commented Aug 26, 2016 at 19:52

Hurricane Development · Accepted Answer · 2016-08-26 19:52:18Z

3

Get result where name starts with a specific letter

SELECT * FROM table WHERE name LIKE 'A%'

Get result where name DOES NOT start with a specific letter

SELECT * FROM table WHERE name NOT LIKE 'A%'

answered Aug 26, 2016 at 19:52

Hurricane Development

2,4682 gold badges21 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL query LIKE getting error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related