Level 29
https://laravel.com/docs/9.x/queries#json-where-clauses
Please compare with the examples shown in the docs, I don't think you are passing the correct parameters.
Jul 19, 2022
6
Level 1
Alternative to whereJsonContains for 5.5 mysql database?
Hey guys as the title suggests is there an alternative way to match what I'm doing with :
$project = Project::whereJsonContains('members', ['email' => Auth::user()->email])->where('id', $request->id)->first();
Because it throws SQLSTATE42000
Level 1
@frankielee It works fine on the localhost but that's because my mysql database is a newer version which has the whereJsonContains feature. Problem is the university library is an older version which doesn't and is throwing the error.
Level 102
Use a different table for the data. Give this a read https://tray2.se/posts/database-design
2 likes
Level 1
@Sinnbeck That seems like a good option but I would need to rewrite a lot of my code, gonna wait a bit to see if I can do it with raw queries and if not this would be the answer
Level 102
@Matter32 I don't think there exists a proper way to do a query on a json column without json support. Your best bet is using LIKE, but that can be extremely flimsy and you are bound to get wrong results.
Another solution is to upgrade your database in production (remember to back up first)
Level 1
@Sinnbeck I got around the json issue by and casting it as an array and it gets the job done. And sadly can't do anything about the database since it's provided from the university. Think your first solution is the best one and guess I will have to grind it out over this weekend.
$table->text("members");
Please or to participate in this conversation.