JSON_OVERLAPS and JSON_CONTAINS_PATH

JSON_OVERLAPS

JSON_OVERLAPS() (MySQL 8.0.17+) returns true if two JSON documents share any elements. JSON_CONTAINS_PATH() checks whether a path exists.

Example

-- Check if any tag matches
SELECT * FROM articles
WHERE JSON_OVERLAPS(tags, '["php", "mysql"]');

-- Check if a path exists
SELECT JSON_CONTAINS_PATH(
  '{"a": {"b": 1}}',
  'one',
  '$.a.b'
);  -- 1 (true)

SQL

Full Editor

Pro Tip

JSON_OVERLAPS is great for tag/category intersection queries.

Related Resources

MySQL Reference

Complete tag & property list

MySQL How-To Guides

Step-by-step practical guides

MySQL Exercises

Practice what you've learned