Welcome Guest, Not a member yet? Register   Sign In
Sql Query Like by Multiple columns
#4

(This post was last modified: 11-12-2022, 08:07 AM by ikesela.)

(11-12-2022, 06:04 AM)UchihaSV Wrote:
(11-12-2022, 12:30 AM)ikesela Wrote:
Code:
$this->userModel->like('CONCAT(last_name,first_name)',$_GET['search']);

Tnx, and if i need space between columns i can use - CONCAT(last_name," ",first_name) or need use something else?

Yes -> can refer this: https://www.mysqltutorial.org/sql-concat-in-mysql.aspx
Reply


Messages In This Thread
Sql Query Like by Multiple columns - by UchihaSV - 11-11-2022, 07:26 PM
RE: Sql Query Like by Multiple columns - by ikesela - 11-12-2022, 08:05 AM



Theme © iAndrew 2016 - Forum software by © MyBB