DWQA QuestionsCategory: LaravelHow to use concat in where clause in doctrine laravel ?
kandy Staff asked 6 years ago

Example :
$query->andWhere(“concat(t.firstName,’ ‘,t.lastName) LIKE :serach_query”)
->setParameter(‘serach_query’, ‘%’.$serach_query.’%’);