+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=11)
+--- Thread: Query for json data type (/showthread.php?tid=79420)
Query for json data type - candra - 06-13-2021
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?
RE: Query for json data type - iRedds - 06-13-2021
$db->where("dataUser ->> 'level' = 'true'", null, false);
RE: Query for json data type - candra - 06-14-2021
(06-13-2021, 09:56 AM)iRedds Wrote: $db->where("dataUser ->> 'level' = 'true'", null, false);
thank you