Is it possible to use CONCAT_WS?
Opened this issue · 0 comments
TriJoe commented
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%'