mysql like with all permutation of words

Question

Helo to all

for example I have row with this filed name : "Happy cow milk";

if I search for "Happy milk" with using "%Happy%milk%" it works, now I want to get this result with this query : "milk Happy" or "milk cow"...

how to I do it ? thanks in advance .

You need to look into [Full text searching](https://dev.mysql.com/doc/refman/8.0/en/fulltext-search.html) — Nick, Feb 06 '19 at 08:30
Possible duplicate of [SQL Fuzzy Matching](https://stackoverflow.com/questions/20064445/sql-fuzzy-matching) — Marcin, Feb 06 '19 at 08:31
Just break all words into multiple rows and store them in another table. — Salman A, Feb 06 '19 at 08:44
NO NO NO NO just full text searching solve the problem <3 thank you @Nick — kiamoz, Feb 06 '19 at 08:50
@kiamoz Your answer doesn't use anything from the question Marcin linked to. — Barmar, Feb 06 '19 at 09:08
I know, that's what I meant in my comment to him. I don't know why you told me to see your answer. — Barmar, Feb 06 '19 at 09:19

score 1 · Accepted Answer · answered Feb 06 '19 at 08:51

1

SELECT * FROM table_name WHERE MATCH(col1, col2)
AGAINST('search terms' IN NATURAL LANGUAGE MODE)

answered Feb 06 '19 at 08:51

kiamoz

1 Answers1