I have a table looking like this:
The data in the index column can look something like this:
If a user now searches for 'trädgård' I would like the query only to give the result those result that exactly match that word. That is, I want to be able to parse and compare each word between the ; sign. The same true if the user searches for 'trädgård' and 'blommor' I want it to exaclty match the customer that have those two words in their index column.
If I do something like this it searches the word in the whole string:
SELECT * FROM customer WHERE index LIKE '%trädgård%'
Open in new window