How to convert query to laravel

Question

I am totally new to laravel. I have a table

    +---------------------+
    | id | Content        |  
    +---------------------+
    |   1  | {"_token":"yAzxyLrdQfVscyc3fNB87PU4e1p6sS4JwX6AfmUQ","datefrom":"2017-07-07","dateto":"2017-07-31","Productivity":"Productivity","Productivityrating":"2","Technical_Skills":"Technical skill","Technical_Skillsrating":"3","Work_Consistency":"Work consistency","Work_Consistencyrating":"4","Presentation_skills":"Presentaion skills","Presentation_skillsrating":"3","test":"test","testrating":"5","cycle_id":"1","save":"proceed"}  | 
    |        
    |       
    |  
    +------+--------------+

field name Content is json. like

 {"_token":"yAzxyLrdQfVscyc3fNB87PU4e1p6sS4JwX6AfmUQ",
    "datefrom":"2017-07-07",
    "dateto":"2017-07-31",
    "Productivity":"Productivity",
    "Productivityrating":"2",
    "Technical_Skills":"Technical skill",
    "Technical_Skillsrating":"3",
    "Work_Consistency":"Work consistency",
    "Work_Consistencyrating":"4",
    "Presentation_skills":"Presentaion skills",
    "Presentation_skillsrating":"3",
    "test":"test",
    "testrating":"5",
    "cycle_id":"1",
    "save":"proceed"}

I want to Search from table where cycle_id=1 I have a mysql query

$sql="SELECT *from table where `Content`->>'$.cycle_id'=1";

How can i convert this to laravel?

like

$user = DB::table('table')->where('Content', '$.cycle_id'=1)->first();

Please help me.Any help would be appreciated

what is this ->> operator?

TIGER
– TIGER

2017-07-11 05:09:35 +00:00
Commented Jul 11, 2017 at 5:09 — TIGER
– TIGER, Commented Jul 11, 2017 at 5:09
@Tiger- I have update the question.please help me

user7540051
– user7540051

2017-07-11 05:24:10 +00:00
Commented Jul 11, 2017 at 5:24 — user7540051
– user7540051, Commented Jul 11, 2017 at 5:24

Pablor · Accepted Answer · 2018-12-10 17:33:48Z

1

Since Laravel 5.6.24, you can use WhereJsonContains(): User::whereJsonContains('content', ['cycle_id' => 1])->get()

answered Dec 10, 2018 at 17:33

Pablor

211 silver badge2 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vishal Tarkar · Accepted Answer · 2017-07-11 05:54:10Z

0

First you need to create model.

You can use

php artisan make:model {TableName}

command to create one.

You can use this query.

$user = DB::table('table')->where('Content->"$.cycle_id"', '1')->first();

or

$user = TableName::where('Content->"$.cycle_id"', '1')->first();

answered Jul 11, 2017 at 5:54

Vishal Tarkar

83612 silver badges32 bronze badges

2 Comments

user7540051 Over a year ago

select * from Appraisal_commnds where Content->'$.""$"'.cycle_id" = 1 limit 1 query like this

user7540051 Over a year ago

Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.cycle_id" = ?

Collectives™ on Stack Overflow

How to convert query to laravel

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related