Mysql Notes

• Retrieving data as json
  • JSON Datatype

        select contact_info,
      JSON_EXTRACT(contact_info,'$') as 'extracted',
      JSON_EXTRACT(contact_info, '$.email') as email,
      JSON_EXTRACT(contact_info, '$.message') as message,
      JSON_EXTRACT(contact_info, '$.fullname') as name,
      JSON_EXTRACT(contact_info, '$.telephone') as telephone
    from wp_contact_us;
    

---

Last update: April 13, 2020 15:25:03