+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28)
+--- Forum: CodeIgniter 4 Support (https://forum.codeigniter.com/forumdisplay.php?fid=30)
+--- Thread: Like with Json field (/showthread.php?tid=90758)
Like with Json field - motoroller - 04-29-2024
I can use where $builder->where("c.Owner->>'$.id'='$owner'", null, false);
how do same with like?
RE: Like with Json field - Bosborne - 04-29-2024
That may depend on what database you use. Postgres, for example, has some support for JSON in its SQL dialect, but not “like”. In my use case I constructed my own search and therefore needed to construct my own paging.