How to search JSON data in MySQL?

by

If you have MySQL version >= 5.7, then you can try this:

SELECT JSON_EXTRACT(name, "$.id") AS name
FROM table
WHERE JSON_EXTRACT(name, "$.id") > 3

Output:

+-------------------------------+
| name                          | 
+-------------------------------+
| {"id": "4", "name": "Betty"}  | 
+-------------------------------+

Please check MySQL reference manual for more details:
https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html

More Related Contents:

  1. MySQL JSON: How to find object from key value
  2. Using MySQL JSON field to join on a table
  3. How to update JSON data type column in MySQL 5.7.10?
  4. MySQL search json value by key in array
  5. How to convert result table to JSON array in MySQL
  6. Storing Data in MySQL as JSON
  7. How do I generate nested json objects using mysql native json functions?
  8. How can write queries in MySQL that can parse JSON data in a column?
  9. Convert JSON array in MySQL to rows
  10. Native JSON support in MYSQL 5.7 : what are the pros and cons of JSON data type in MYSQL?
  11. How to retrieve JSON data from MySQL?
  12. How to create and insert a JSON object using MySQL queries?
  13. MySQL vs. JSON – Why? [closed]
  14. How to search JSON array in MySQL?
  15. How to create a MySQL hierarchical recursive query?
  16. MySQL Error 1215: Cannot add foreign key constraint
  17. mySQL convert varchar to date
  18. MySQL error code: 1175 during UPDATE in MySQL Workbench
  19. How do you select every n-th row from mysql
  20. Add Foreign Key to existing table
  21. MySQL maximum memory usage
  22. MySQL JOIN the most recent row only?
  23. INSERT … ON DUPLICATE KEY UPDATE with WHERE?
  24. org.json.JSONException: Value
  25. Error #2002 Can’t connect to local MySQL server through socket ‘/Applications/MAMP/tmp/mysql/mysql.sock’ (2)
  26. Using index, using temporary, using filesort – how to fix this?
  27. How to get the max of two values in MySQL?
  28. How to make a primary key start from 1000?
  29. MySQL – SELECT * INTO OUTFILE LOCAL ?
  30. how to partition a table by datetime column?

Leave a Comment