Sql Query Like by Multiple columns |
Hello, i use SQL QB and it's fine, but i need use more flexible - need find data by one string but in multiple concat columns (first_name, last_name, patronymic).
For example i need find string "Mark Suckerberg" in first_name + last_name columns (without OR, AND) - need generate sql part as "where (first_name + last_name) like '%string%'", but SQL QB like, orLike generated extra escaping and it's not work correctly: PHP Code: ... Any suggestion? (11-12-2022, 06:04 AM)UchihaSV Wrote:(11-12-2022, 12:30 AM)ikesela Wrote: Yes -> can refer this: https://www.mysqltutorial.org/sql-concat-in-mysql.aspx (11-12-2022, 08:05 AM)ikesela Wrote: Yes -> can refer this: https://www.mysqltutorial.org/sql-concat-in-mysql.aspxOk, then i can use CONCAT_WS like implode. |
Welcome Guest, Not a member yet? Register Sign In |