MySQL results order

Question

I've got a query splitting phrase to words and showing result:

SELECT (...) WHERE 'name' LIKE '%word1%' AND 'name' LIKE '%word2%' ... etc

My problem is that when I type 'word1 word2' than the results are different than for 'word2 word1'.

Why is that ? What causes it and how to fix it ?

Wrap off quotes from table and column name instead use backtick — Saty, Jul 22 '16 at 09:10

score 0 · Answer 1 · answered Jul 22 '16 at 09:11

0

Use or condition

SELECT (...) WHERE 'name' LIKE '%word1%' or'name' LIKE '%word2%' ... etc

answered Jul 22 '16 at 09:11

Sumit patel

score 0 · Answer 2 · edited May 23 '17 at 12:15

0

change single quotes ' to backtick and use OR operator

SELECT (...) WHERE `name` LIKE '%word1%' OR `name` LIKE '%word2%' ... etc

edited May 23 '17 at 12:15

Community

answered Jul 22 '16 at 09:11

Niklesh Raut

I did it sir - nothing happened. – user6624349 Jul 22 '16 at 09:19
@user6624349 : use `OR` operator with backtick – Niklesh Raut Jul 22 '16 at 09:28
Try with `OR` operator with backtick – Niklesh Raut Jul 22 '16 at 09:30

score 0 · Answer 3 · answered Jul 22 '16 at 10:03

0

why you separate them when you want 2 words in the same column?

Use this:

SELECT (...) WHERE 'name' LIKE '%word1%word2%' OR 'name' LIKE '%word2%word1%' ... etc

answered Jul 22 '16 at 10:03

PSo

3 Answers3