I am trying to perform a "process of elimination" type of search using MySql.
I have a table with a lot of values that people could search for- and currently if they search for 1 value it works great. But if they search for lets say "value1 value2" it doesn't work at all because there is no entries with those values.
So to solve that problem- i explode based off of spaces and then I have an array of different values so it would be like this
arrayVal = value1
arrayVal = value2
My question is how can I perform a query that selects all of the possible matches to "value1" store them then search "value2" against the results from "value1". I hope this makes sense.
Any help would be greatly appreciated!