I have a query that looks for matching criteria in two columns, when using this query either/or gets selected, I need it to only pick the records that match both??
SELECT ProdCAT1 FROM $tableName WHERE ProdCAT1 LIKE '%$siteword%' AND ProdSELECT LIKE '%$brandword%'
Any pointers? I can't use PHP, it must be done in the query...