How to Search Comma Separated Values in Laravel

Websolutionstuff | Sep-15-2021 | Categories : Laravel

Today, in this post i will show you how to search comma separated values in laravel. Here, we will find specific id from comma separated value and will get comma separated values from the table.

Here, we will search comma separated values using FIND_IN_SET() function. FIND_IN_SET() is predefine function of php mysql, here, we will use FIND_IN_SET() with whereRow() of laravel query builder for laravel comma separated search example. So let's see how to search comma separated values in laravel.

First of al we need to create 2 tables for find specific id from comma separated value. I have posts and tags tables in my website.

1) In posts table we have "ID", "name", "tag_id" 

2) In tags table we have "ID", "name"

Here, we will find records that have ID "1" from "tag_id" column of posts table.

$search_id = 1;
$data = \DB::table("posts")
    ->select("posts.*")
    ->whereRaw("find_in_set('".$search_id."',posts.tag_id)")
    ->get();

 

 

And you will get output like below.

Illuminate\Support\Collection Object
(
    [items:protected] => Array
    (
        [0] => stdClass Object
            (
                [id] => 1
                [name] => post1
                [tag_id] => 1,2
            )

        [1] => stdClass Object
            (
                [id] => 2
                [name] => post2
                [tag_id] => 1
            )
    )
)

 


 

You might also like :

Recommended Post
Featured Post
How To Check Array Is Empty Or Null In Javascript
How To Check Array Is Empty Or...

In this example, I will show you how to check if an array is empty or null in javascript or jquery. When we are wor...

Read More

Aug-18-2020

How To File Upload In Angular 15 Example
How To File Upload In Angular...

As an Angular 15 developer, I understand the significance of incorporating file upload functionality into web applicatio...

Read More

Jun-19-2023

How to Search with Pagination in Laravel 10 Vue 3
How to Search with Pagination...

Hey everyone! Ever found yourself in need of a straightforward example for integrating search and pagination in a Larave...

Read More

Jan-01-2024

How To Create Calendar Event In Laravel 9 Using AJAX
How To Create Calendar Event I...

In this article, we will see how to create a calendar event in laravel 9 using ajax. Here, we will learn how to add...

Read More

Dec-28-2022