How to use updateOrInsert() method in Laravel Query?

-
updateOrInsert() method is used to update an existing record in the database if matching the condition or create if no matching record exists. Its return type is Boolean. Syntax DB::table(‘blogs’)->updateOrInsert([Conditions],[fields with value]); Example DB::table(‘blogs’)->updateOrInsert( ['email' => 'info@bestinterviewquestion.com', 'title' => 'Best Interview Questions'], ['content' => 'Test Content'] );

Popular posts from this blog

SQL In Static Id Wise Record Skip After Show Result

-
Example SELECT     pr.*,     sub_cat.name AS subcategoryname FROM     products AS pr     JOIN product_sub_categories AS sub_cat    ON sub_cat.id = pr.sub_category_id     JOIN product_categories AS cat         ON cat.id = sub_cat.category_id WHERE       pr.`is_discontinued` = 0     AND pr.`is_active` = 1     AND pr.deleted_by IS NULL     AND sub_cat.`is_active` = 1     AND cat.`is_active` = 1     AND cat.id NOT IN (1,5)     AND cat.deleted_by IS NULL ORDER BY pr.name ASC , cat.id;
Read more