search

ThingEngineer / PHP-MySQLi-Database-Class

Wrapper for a PHP MySQL class, which utilizes MySQLi and prepared statements.
Other
3.3k stars 1.34k forks source link

Is it possible to use CONCAT_WS? #992

Open TriJoe opened 2 years ago

TriJoe commented 2 years ago

I'm writing a search function that needs to look in multiple columns. I don't see a way to use CONCAT_WS. Is it possible to do?

SELECT * 
FROM pages 
WHERE CONCAT_WS('', column1, column2, column3) LIKE '%keyword%'