Laravel Course - The PHP Framework > Laravel - Database

Laravel Query Builder - whereIn, whereNull, whereDate and whereColumn Queries

16.3k
Overview

In this Laravel course, we will learn about the  Laravel whereColumn(), whereDate(), whereIn()  and whereNull() functions.

Laravel provides a number of methods that can be used to filter data by column, date, in range and null.

The Laravel whereColumn() method returns the subset of the table for which the given column has a value that matches the given expression. The Laravel whereDate() method returns the subset of the table for which the given column has a date that matches the given expression. The whereIn() Laravel method returns all rows from the table for which any of its columns (or expressions) match one or more values from an array passed to it as parameter. The whereNull() Laravel method returns all rows from the table for which any of its columns (or expressions) are null.

The whereColumn(), whereDate(), whereIn() and whereNull() functions provide a convenient way of filtering data based on column, date, range or null values respectively. It helps developers to create effective applications that are easy to maintain and update. Laravel has been designed keeping in mind the modern web development standards and best practices.

The whereColumn(), whereDate(), whereIn() and whereNull() functions are very useful when it comes to query building. These functions help in filtering the data in an efficient way without adding much complexity to the code.

The advantages of using Laravel's whereColumn(), whereDate(), whereIn() and whereNull() functions for any user are many.  Laravel's whereColumn() function will perform the appropriate query for you based on the supplied column name.function will perform the appropriate query for you based on the supplied column name. WhereDate() and WhereIn() functions do similar things to whereColumn(), but they additionally accept a time/date range in addition to a column name.and functions do similar things to, but they additionally accept a time/date range in addition to a column name. WhereNull() function will return results for null values.function will return results for null values.


See More

The whereIn() function in Laravel provides a convenient way to filter a given array or collection of data. It is used to find items that matches the given criteria.

The whereIn() function has two parameters:

- The first parameter is an array or collection of data

- The second parameter is a string, string array, or callback containing the conditions that need to be matched

The whereIn() function in Laravel is used to filter the data based on a specified key. It returns the list of all items that match the condition.

This function is very useful when we need to filter out a specific set of data from a larger set. The whereIn() function is also useful when we need to compare two arrays and return only those items which are present in both arrays.

Laravel whereColumn() is used to filter records by a given column.

The whereColumn() method accepts a string as its first argument. This string can be the name of any column in the table or it can be an expression using SQL’s LIKE operator.

It returns a new instance of Eloquent that will only return records that match the condition specified by the first argument to this method.

The Laravel whereColumn() method filters the query by one or more columns. If a column is not passed, it will filter the query by all columns.

The following example will return all rows in the posts table that have a 'title' column that contains "hello world".

$q = DB::table('posts')->whereColumn('title', 'hello world');

What is the Laravel whereDate() used for?

This function is used to find the date for a given relative time. The syntax for this function is as follows:

whereDate($relativeTime, $dateFormat)

The first parameter $relativeTime is the time in which you want to know about. The second parameter $dateFormat is the format of the date that you want to know about.

The whereNull() function is useful for those who need to find out if a given value is null. This function can be used in various ways, such as finding out if a table column has any null values or checking if a given value is null.

whereNull() will assist you in retrieving data from a database that contains null values. whereNotNull() will assist you in retrieving data from a database that has not null values.

To use a sql wherein query, Laravel provides wherein(). We only need to supply two arguments to wherein(), one for the column name and another for an array of ids or whatever we desire. The syntax for wherein query in Laravel is shown below: whereIn(Coulumn_name, Array);

WhereIn and WhereColumn queries are two different types of queries in a SQL database. They both use the same WHERE clause but the difference is that whereIn takes a row number and whereColumn takes an index number.

WhereIn: Returns the text of a column that contains the word "in" in an input field. WhereNull: Returns null if a column contains no text in an input field. WhereDate: Returns the value of a date column as a string. WhereColumn: Returns the text of a column that contains the given text in an input field.

WhereIn queries return the list of all the columns in a table. WhereColumn queries return a list of all the cells in a column.

Learner's Ratings

4.4

Overall Rating

  • 81%
  • 3%
  • 6%
  • 6%
  • 4%

Reviews

A
Abdul Sattar
5

Please update course

A
Ali Haidar
5

awesome

M
Muzammal
5

Best Experience Ever

J
Jatin
5

this tutorial help me to learn laravel .. Outstanding Course

G
gautam metaliya
5

good experiance

B
bokhtiar toshar
5

Thank you so much,

A
Anuj Tyagi
5

Thank you so much. You are doing a good job and your way of teaching is very good.

M
mohit mistry
5

Sir, very good explanation in video but sir which screen recoder you used for making this kind of video???

R
RUPESH MISHRA
5

sir please make a video how to use bootstap in laravel without cdn link..

Y
YSK Developer
5

informative

Show More
Recommended Courses
Course Content

  1. Introduction to Laravel Framework
    13m 3s

  1. Prerequisite to Learn Laravel
    15m 26s
  2. Composer
    13m 44s
  3. Installation of Laravel
    12m 46s
  4. Folder and File Structure of Laravel
    19m 46s
  5. Sample Laravel Application
    10m 44s

  1. Laravel Routing - Basic Routing and Redirect Routes
    15m 28s
  2. Laravel Routing - View Routes, Named Routes, Route Parameters and Route Caching
    21m 34s
  3. Assignment: Laravel Routing
    3m 26s

  1. Introduction to Laravel Controller
    11m 11s
  2. Routing Controllers in Laravel
    8m 43s
  3. Resource Controllers in Laravel
    18m 23s
  4. Assignment: Laravel Controller
    3m 28s

  1. Introduction to Middleware
    11m 35s
  2. Global Middleware in Laravel
    12m 25s
  3. Group Middleware in Laravel
    13m 33s
  4. Route Middleware in Laravel
    10m 32s
  5. Controller Middleware in Laravel
    11m 4s
  6. Assignment: Laravel Middleware
    5m 12s

  1. Laravel Views
    17m 48s
  2. Passing Data to Views
    18m 48s
  3. Assignment: Laravel Views
    2m 28s

  1. Introduction to Blade Template
    14m 23s
  2. Blade Directives - Conditional Statements
    22m 46s
  3. Blade Directives - Iterative Statements
    19m 9s
  4. Laravel Components
    15m 57s
  5. Assignment: Laravel Blade Template
    2m 45s

  1. Laravel Helpers
    8m 2s
  2. Laravel Helpers - Array and Object Methods
    16m 8s
  3. Laravel Helpers - Path Methods
    7m 9s
  4. Laravel Helpers - String Methods
    18m 10s
  5. Laravel Helpers - Fluent String Methods
    12m 15s
  6. Laravel Helpers - URL Methods
    14m 3s
  7. Laravel Helpers - Miscellaneous Methods
    18m 13s
  8. Laravel Custom Helpers
    23m 58s
  9. Assignment: Laravel Helpers
    1m 20s

  1. Laravel HTTP Client
    18m 53s
  2. Laravel HTTP Request Methods
    19m 23s
  3. Laravel HTTP Request Methods Demo
    13m 42s
  4. Assignment: Laravel HTTP Client
    2m 38s

  1. Laravel Session
    13m 47s
  2. Laravel HTTP Session Handling
    18m 35s
  3. More About Laravel HTTP Session Handling
    15m 31s
  4. Session Flash Data in Laravel
    27m 46s

  1. Introduction to Laravel Database
    14m 8s
  2. Laravel Database - Running SQL Queries
    23m 24s
  3. Laravel Query Builder - Retrieving Data
    18m 40s
  4. Laravel Query Builder - Aggregate Functions
    13m 32s
  5. Laravel Query Builder - Select Statements
    15m 50s
  6. Laravel Query Builder - Joins and Unions
    16m 16s
  7. Laravel Query Builder - where and wherebetween Queries
    17m 45s
  8. Laravel Query Builder - whereIn, whereNull, whereDate and whereColumn Queries
    18m 7s
  9. Laravel Query Builder - Ordering
    8m 34s
  10. Laravel Query Builder - Grouping
    7m 29s
  11. Laravel Query Builder - Limit and Offset
    7m 57s
  12. Laravel Query Builder - Insert, Update and Delete Statements
    22m 13s
  13. Laravel Database - Migrations
    17m 44s
  14. Laravel Database - Migration Commands
    14m 24s
  15. Laravel Database - Seeding
    20m 2s
  16. Assignment: Laravel Query Builder
    2m 17s

  1. Laravel Eloquent ORM - Introduction & Models
    20m 15s
  2. Laravel Eloquent ORM - One To One Relationship
    25m 40s
  3. Laravel Eloquent ORM - One To Many Relationship
    4m 45s
  4. Laravel Eloquent ORM - Many To Many Relationship
    12m 15s
  5. Laravel Eloquent ORM - Has One Through Relationship
    30m 46s
  6. Laravel Eloquent ORM - Has Many Through Relationship
    13m 10s
  7. Laravel Eloquent ORM - One to One Polymorphic Relationship
    25m 33s
  8. Laravel Eloquent ORM - One to Many Polymorphic Relationship
    4m 30s
  9. Laravel Eloquent ORM - Many to Many Polymorphic Relationship
    21m 40s
  10. Laravel Eloquent ORM - Accessors
    13m 36s
  11. Laravel Eloquent ORM - Mutators
    8m 10s
  12. Assignment: Laravel Eloquent ORM
    2m 32s

  1. Laravel Route Model Binding - Implicit Binding
    21m 30s
  2. Laravel Route Model Binding - Explicit Binding
    12m 54s
  3. Assignment: Laravel Route Model Binding
    1m 12s

  1. Laravel - Basics of Localization
    20m 16s
  2. Laravel - More About Localization
    11m 43s
  3. Laravel - Localization Example
    27m 45s
  4. Assignment: Laravel Localization
    1m

  1. Laravel CRUD Operations - Initialization
    17m 55s
  2. Laravel CRUD Operations - Create Operation
    22m 39s
  3. Laravel CRUD Operations - Image Upload
    7m 58s
  4. Laravel CRUD Operations - Read Operation
    10m 21s
  5. Laravel CRUD - Show Operation
    16m 48s
  6. Laravel CRUD - Update Operation
    14m 7s
  7. Laravel CRUD - Delete Operation
    4m 13s
  8. Laravel CRUD - Pagination
    7m 7s

  1. Laravel Validations
    23m 37s
  2. Assignment: Laravel Validations
    1m 47s

  1. Laravel - Mail
    32m 44s
  2. Assignment: Laravel Mail
    1m 36s

  1. Laravel - Queues and Jobs
    14m 44s
  2. Laravel - Queues and Jobs Example
    19m 1s
  3. Assignment: Laravel Jobs and Queues
    1m 37s

  1. Laravel - Events
    24m 10s
  2. Assignment: Laravel Events
    1m 51s

  1. Laravel - Artisan Console
    12m 33s
  2. Laravel - Artisan Console Closure Commands
    9m 24s
  3. Laravel - Artisan Console Input Expectations
    12m 32s
  4. Laravel - Artisan Console Command I-O
    22m 12s
  5. Laravel - Artisan Console Programmatically Executing Command
    13m 15s
  6. Laravel - Artisan Console Task Scheduling
    12m 14s
  7. Assignment: Laravel Artisan Console
    2m 10s

  1. Laravel - Introduction to API
    12m 18s
  2. Laravel API CRUD Operations - Read Operation
    13m 43s
  3. Laravel API CRUD Operations - Create Operation
    18m 54s
  4. Laravel API CRUD Operations - Update Operation
    11m 8s
  5. Laravel API CRUD Operations - Delete Operation
    9m 32s

  1. Introduction and Basic Internal Changes in Laravel - 9
    21m 5s
  2. Controller Route Group in Laravel - 9
    8m
  3. Full-Text Indexes and Where Clauses in Laravel - 9
    14m 4s
  4. Accessors and Mutators in Laravel - 9
    10m 53s
  5. Enum Eloquent Attribute Casting in Laravel - 9
    11m 53s
  6. Implicit Route Binding with Enum in Laravel - 9
    6m 1s
  7. Rendering Inline Blade Templates in Laravel - 9
    6m 3s
  8. New Helpers in Laravel - 9
    10m 21s

  1. Laravel Project - Template Integration
    15m 29s
  2. Laravel Project - User Registration
    44m 20s
  3. Laravel Project - Authentication
    18m 34s
  4. Laravel Project - Manage User Profile
    24m 37s
  5. Laravel Project - Forgot Password
    33m 16s
  6. Laravel Project - Admin Panel Integration
    25m 23s
  7. Laravel Project - Manage Users Module
    50m 26s
  8. Laravel Project - Manage Brands Module
    41m
  9. Laravel Project - Manage Products Module
    49m 49s
  10. Laravel Project - Insert Product Data Using Faker
    12m 54s
  11. Laravel Project - Show Products on the Home Page
    40m 2s
  12. Laravel Project - Manage Product List with Filters
    28m 9s
  13. Laravel Project - Manage Cart Functionality
    38m 36s
  14. Laravel Project - Store Order Functionality
    29m 8s
  15. Laravel Project - List Order Functionality
    42m 59s

  1. Course Summary
    10m 22s

  1. Interview Questions Part 1
    22m 2s
  2. Interview Questions Part 2
    28m 13s

  1. Career Guidelines
    14m 56s
Enroll For Free