MySQL Like

We would like to achieve this result

WHERE text LIKE "%quick%"
AND text LIKE "%brown%"
AND text LIKE "%fox%"


Searching for 'fein multi master' should product the same results as 'fein multimaster'

It seems like we could achieve this with either regex or ngrams but our developers are having a hard time achieving this.

Has any had any success with something like this?

This is what Elasticsearch was built for. Have a look at the section around full-text queries in the documentation.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.