codehaven - php snippets - coding help
[wd_asp elements=’search’ ratio=’100%’ id=1]
octopus energy discount code

Find text in multiple columns/fields – concat

24th July 2015

MySql

mysql codehaven category

SELECT * FROM mytable
WHERE (CONCAT(Column1, Column2) LIKE '%keyword1%')
AND (CONCAT(Column1, Column2) LIKE '%keyword2%')