How can write queries in MySQL that can parse JSON data in a column?

by

You could use json_extract (5.7 up).
https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html#function_json-extract

SELECT user_id, json_data
FROM articles 
WHERE json_extract(json_data, '$.title') LIKE '%CPU%';

More Related Contents:

  1. How to search JSON data in MySQL?
  2. How to convert result table to JSON array in MySQL
  3. Storing Data in MySQL as JSON
  4. How do I generate nested json objects using mysql native json functions?
  5. MySQL JSON: How to find object from key value
  6. Using MySQL JSON field to join on a table
  7. Convert JSON array in MySQL to rows
  8. Native JSON support in MYSQL 5.7 : what are the pros and cons of JSON data type in MYSQL?
  9. How to retrieve JSON data from MySQL?
  10. How to update JSON data type column in MySQL 5.7.10?
  11. How to create and insert a JSON object using MySQL queries?
  12. MySQL search json value by key in array
  13. MySQL vs. JSON – Why? [closed]
  14. Out of memory Microsoft VBScript runtime error 800a0007
  15. Left Outer Join doesn’t return all rows from my left table?
  16. How can i optimize MySQL’s ORDER BY RAND() function?
  17. Are table names in MySQL case sensitive?
  18. Get table names using SELECT statement in MySQL
  19. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  20. Can a foreign key reference a non-unique index?
  21. SQL keys, MUL vs PRI vs UNI
  22. How does a MYSQL Self-Join Work?
  23. How to change the default port of mysql from 3306 to 3360
  24. How to move columns in a MySQL table?
  25. Where to change the value of lower_case_table_names=2 in XAMPP on Windows?
  26. What is the best MySQL collation for German language
  27. quick selection of a random row from a large table in mysql
  28. MySQL Select Query – Get only first 10 characters of a value
  29. Xampp-mysql – “Table doesn’t exist in engine” #1932
  30. Unserialize through query at database level itself

Leave a Comment