I'm confusing myself and wonder if someone can point me in the right direction?
Say I have a search box on my page and someone types in 3 words, w1, w2 and w3.
I'm thinking about writing SELECT statements for all of the following and join them in order in a UNION.
"w1 w2 w3"
w1 AND w2 AND w3
w1 AND w2
w1 AND w3
w2 AND w3
w1 OR w2 OR w3
Am I thinking about this right?