MySQL Like


(Michael Gartner) #1

We would like to achieve this result

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

Example

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?


(Christian Dahlqvist) #2

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


(system) #3

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