Why is my query only searching for names that start and end with a and neglecting the names that start and end with m?

Question

select plantcode, plantname 
from `plant` 
where plantname like 'a%a' or 'm%m';

after I execute the query, it gets only the names that start and end with a from my database, while I also asked for words that also start and end with m!

already tried that, it shows then only the words that start and end with m — Ghaith Hatamleh, Mar 10 '20 at 12:26

score 1 · Answer 1 · answered Mar 10 '20 at 12:25

1

That's just a wrong syntax - having or m%m in the end without a matching column won't yield the expected result. You have to repeat that plantname:

select plantcode, plantname 
from `plant` 
where plantname like 'a%a' or plantname like 'm%m';

answered Mar 10 '20 at 12:25

Nico Haase

11,420
35
43
69

i also did that, it then neglects the words that start and end with a! – Ghaith Hatamleh Mar 10 '20 at 12:28
nvm it worked, thanks – Ghaith Hatamleh Mar 10 '20 at 12:28
and to display names that have only 5 letters or more? – Ghaith Hatamleh Mar 10 '20 at 12:29
Please open a new question if you want to ask something else – Nico Haase Mar 10 '20 at 12:30

Why is my query only searching for names that start and end with a and neglecting the names that start and end with m?

1 Answers1