MySQL JSON search

gistfile1.txt

Instead of using regexp like so:
ancestors column would be something like: {"category": 1}
WHERE  `ancestors` REGEXP '(.*\"category\":\"1\")'

Use the JSON functions:
WHERE JSON_EXTRACT(`ancestors`, 'category') = 1

Arrays:
WHERE JSON_SEARCH(JSON_EXTRACT('{"categories": [1,2,3]}', 'categories'), "1") != null

More info:
https://blogs.oracle.com/svetasmirnova/ (usefull blog)
http://labs.mysql.com/ (Download page, select MySQL JSON UDFs 0.3.3)
https://fosdem.org/2015/schedule/event/moving_to_nosql/ (fosdem talk from Sveta Smirnova - Oracle)