I want to use this query into my laravel application, but I don't know how to write the IF part!
SELECT
`users`.* ,
IF(`friends`.`user_id` = '2' , TRUE , FALSE) AS `user_friend`
FROM `users`
LEFT JOIN `friends` ON `friends`.`friend_id` = `users`.`id` AND `friends`.`user_id` = '2'
WHERE `users`.`id` != '2'