• 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
MySQL JSON fields support in query builder

#8
MY  intial take on this:

1) Would need to check the table for json column type.

2) To pull json data out of the table we would need to use the column path operator (->)
    but then the data is surrounded by double quote marks ("data").

3) If the column type is json we would need to use the inline path operator to get the
    column values (->>).

4) Queries would need to access the table data using the column-name and inline path operator (->>).

5) One problem I see here is the (column path operator ->) and the (inline path operator ->>)
    (the -> and ->>) are going to interfere with the PHP operator (->).

5) This would also effect the DBForge.
What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )
Reply


Messages In This Thread
RE: MySQL JSON fields support in query builder - by InsiteFX - 08-16-2020, 03:47 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.