Level 75
Just use as is, example: https://laracasts.com/discuss/channels/laravel/sql-native-to-query-builder
Bind your parameters.
May 13, 2021
3
Level 1
how to excute this query in laravel?
the query I want to excute in laravel in pure sql
SELECT p.id,title,post_content,image_dir,video_dir,p.created_at,first_name,last_name,profile_img FROM users AS u,posts AS p WHERE title like '%mo%' OR post_content like '%mo%' AND user_id=u.id
Level 1
thanks, it work, but the problem is that i want to replace mo with a variable name $key but when i tried to do that it didn't return any records
Level 75
WHERE title like :key
$bindings = ['title' => "%" . $key . "%"];
Just like example in link. Do same for post_content.
Please or to participate in this conversation.