• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Tutsplanet

Tutsplanet

Free Technical and Blogging Resources

  • Home
  • Web Hosting
  • Programming
  • Plugins
  • Twitter Trends
  • Tools
  • About Us

Programming TagsLaravel

Laravel Eloquent- Where Condition with Two Columns

Sep 14, 2022 Editorial Staff Leave a Comment

Share
Tweet
Share

Did you ever think about how to write where condition with two columns(fields) in Laravel Eloquent? In the first place, this is possible in Laravel using the function whereColumn.

For example, you have two fields named sub_total and grand_total, and you need to find all the orders have the same sub_total as grand_total.

So you can use the whereColumn to get the desired results.

Example 1
/**
 * The attributes that are mass assignable.
 *
 * @var array
 */
 public function index()
 {
    $orders = Order::whereColumn('sub_total','grand_total')
                ->get();
    dd($orders);
}
Example 2

Also, you can use a comparison operator with this method, the same as the where method.

public function index()
{
    $orders = Order::whereColumn('updated_at', '<', 'created_at')
                ->get();
    dd($orders);
}
Example 3

The whereColumn method can also be passed an array of multiple conditions. The multiple parameters will be joined with an and operator.

/**
 * Example for whereColumn
 *
 * @var array
 */
 public function index()
 {
    $orders = Order::whereColumn([
                    ['sub_total', '=', 'grand_total'],
                    ['created_at', '<', 'updated_at'],
                ])->get();
    dd($orders);
 }
Did this post help you?
Tutsplanet brings in-depth and easy tutorials to understand even for beginners. This takes a considerable amount of work. If this post helps you, please consider supporting us as a token of appreciation:
  • Just want to thank us? Buy us a Coffee
  • May be another day? Shop on Amazon using our links.
    Your prices won't change but we get a small commission.

Editorial Staff

Editorial Staff at Tutsplanet is a dedicated team to write various tutorials about subjects like Programming, Technology and Operating Systems.

View all posts by Editorial Staff

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Quick Links

  • Top 21 Website Ideas To Make Money Online in 2021
  • A Simple YouTube Video Downloader Script in PHP
  • The 50 Most Useful jQuery Plugins for Frontend Development
  • Replace “\n” with new line characters, using Notepad++
  • Using Third-Party Libraries in Codeigniter
  • Upload Multiple Images and Store in Database using PHP and MySQL.
  • Hierarchical Tree view Category Example in Laravel
  • Laravel Image Intervention Tutorial With Example
  • How to import sql file in MySQL database using PHP?
  • Free VAT Calculator Online

Subscribe

* indicates required

Search Here

Share

   

Hot topics

  • Replace “\n” with new line characters, using Notepad++ 8 views
  • How Get Current URL from a PHTML – Magento 2 7 views
  • All Countries SQL file with Country Codes to Download 6 views
  • Open a URL in a new tab using JavaScript 5 views
  • PHP: Implode () with quotes 5 views
  • Use Mpdf in Codeigniter 3 4 views
  • How to enter new line in Microsoft Teams? 4 views
  • Add FTP/SFTP in Visual Studio Code 4 views
  • Auto Login in PuTTY with a password 4 views
  • Laravel Eloquent Select Column as Alias 3 views

Categories

  • Design & Development
  • Drupal
  • Facebook
  • General
  • How To
  • ios
  • Javascript
  • Linux
  • Magento
  • Marketing
  • News
  • PHP
  • Plugins
  • Programming
  • Snippets List
  • Social Media
  • Softwares
  • Themes
  • Tips
  • Wordpress
  • YouTube

Copyright © 2023 · Planet on Genesis Framework · Powered By BunnyCDN . Network wallpapernoon.com