ThingEngineer/PHP-MySQLi-Database-Class

Is it possible to use CONCAT_WS?

Opened this issue · 0 comments

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%'