My where clause is not working. How can I use not and like?
->where([‘not’, [‘fav_id’ => null]], [‘and’, [‘like’, ‘title’, $search_text]])
My where clause is not working. How can I use not and like?
->where([‘not’, [‘fav_id’ => null]], [‘and’, [‘like’, ‘title’, $search_text]])
->where(['and',
['not', ['fav_id' => null]],
['like', 'title', $search_text]
])
would result in SQL:
WHERE (NOT fav_id IS NULL AND title LIKE $search_text )
Thank you.