Welcome Guest, Not a member yet? Register   Sign In
Query for json data type
#1

I'm new to CI4 sql builder, I'm trying to query the postgresql json data type, for example:

$db->where("dataUser ->> 'level' ",'true');
or $db->query("select * from login ul where dataUser ->> 'level' = 'true'");

when i run getCompiledSelect,
SELECT * FROM "login" WHERE dataUser ->> 'level' > :dataUser -> > 'level':
and
SELECT * FROM "login"
what can i do?
Reply
#2

(This post was last modified: 06-13-2021, 09:57 AM by iRedds.)

$db->where("dataUser ->> 'level' = 'true'", null, false);
Reply
#3

(06-13-2021, 09:56 AM)iRedds Wrote: $db->where("dataUser ->> 'level' = 'true'", null, false);

thank you
Reply




Theme © iAndrew 2016 - Forum software by © MyBB