• 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

Laravel db raw and whereRaw() where clause example

Dec 6, 2021 Editorial Staff Leave a Comment

Share
Tweet
Share

Laravel Eloquent provides endless methods to query your database and make good collections.

But if you need to have normal MySQL expression in Laravel eloquent, such as replace white spaces from a field when using the where condition.

This will help to push some of the limits that are with the Eloquent in Laravel.

You can use the whereRaw() for this instance.

For example, I need to get the count of a mobile number existing in the database. But we have a situation here as some of the mobile numbers were entered previously with spaces and some of them are without spaces. In the first place, we need to remove the spaces for both input and database records before comparison takes place.

Basically, there are two methods you can use to

Using whereRaw()

$count = Customer::whereRaw("REPLACE(phone,' ', '') = '+1 98 90 891223'")
            ->count();

dd($count);

However, there is an alternate solution for this using the DB::raw() which will produce the same result as above.

Using DB::raw()

$count = Customer::where(DB::raw("REPLACE(phone,' ', '') = '+1 98 90 891223'"))
            ->count();

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++ 38 views
  • How to enter new line in Microsoft Teams? 34 views
  • Simple PHP Shopping Cart 18 views
  • Add FTP/SFTP in Visual Studio Code 15 views
  • Open a URL in a new tab using JavaScript 13 views
  • Solution: windows photo viewer opens each time save a pic file 12 views
  • Laravel: Download files to storage from SFTP 12 views
  • A Simple YouTube Video Downloader Script in PHP 11 views
  • Laravel Eloquent Select Column as Alias 10 views
  • Get Uploads Directory Path in WordPress 9 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