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 :
In this article, we will see laravel 9 one to many polymorphic relationship. A one-to-many polymorphic relation is...
Apr-05-2022
Hello, laravel web developers! In this article, we'll see how to image upload in laravel 11 Livewire. Here, we'l...
Jun-07-2024
In this article, we will give you information about middleware and we will see how to create custom middleware in l...
Aug-24-2020
In this tutorial we will see how to generate QR code using javascript. we will implement QR code generator without...
Jul-19-2021