I would like to match two words in a query but the two word might switch order e.g
“SELECT * FROM products WHERE class LIKE '%”.$search."%’ ORDER BY class, sliderpos ";
“product” might be for example silver trays
but search might be “trays silver”
Whats the correct query as I don’t think my current one is always matching.
Much appreciated.
