• 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++ 55 views
  • How to enter new line in Microsoft Teams? 40 views
  • Open a URL in a new tab using JavaScript 28 views
  • A Simple YouTube Video Downloader Script in PHP 25 views
  • Laravel WhereHas() Eloquent Example 24 views
  • How to change PHP version on MAMP – Mac OSX 19 views
  • How to Create PDF File From HTML Form Using Fpdf? 17 views
  • PHP: Implode () with quotes 16 views
  • Simple PHP Shopping Cart 14 views
  • Solution: windows photo viewer opens each time save a pic file 13 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 © 2022 · Planet on Genesis Framework · Powered By BunnyCDN . Network wallpapernoon.com