Solution
I replaced the question mark operator :
SELECT * FROM tracks WHERE artistnames @> '"The Dirty Heads"'
I don't know if there are performance differences between the two search operators. More infos: http://www.postgresql.org/docs/current/interactive/functions-json.html#FUNCTIONS-JSONB-OP-TABLE
Last updated
9 years ago.
Hello, I've answered a similar question on stackoverflow, using the function call instead of ? operator might be an alternative.
SELECT oprname, oprcode FROM pg_operator WHERE oprname = '?'
on my database it's jsonb_exists function, then you can update your query as:
Track::whereRaw("jsonb_exists(artistnames, 'The Dirty Heads')")->first();
Last updated
9 years ago.
Sign in to participate in this thread!
Laravel
Laravel News
Laracasts
Laravel Podcast