Live Webinar | From Strategy to Execution: Your Practical MySQL to MariaDB Migration Plan
Register Now
LogoLogo
CtrlK
Download MariaDBContact Us
  • Home
  • MariaDB Platform
  • Server
  • MaxScale
  • Analytics
  • Galera Cluster
  • Connectors
  • Tools
  • MariaDB Cloud
  • Release Notes
  • General Resources
  • MariaDB Server Documentation
  • Quickstart Guides
  • Server Usage
  • Server Management
  • Security
  • Architecture
  • Clients & Utilities
  • HA & Performance
  • Reference
    • SQL Structure
    • SQL Statements
    • SQL Functions
      • Functions & Operators
      • Aggregate Functions
      • Control Flow Functions
      • Date & Time Functions
      • Numeric Functions
      • Pseudo Columns
      • Secondary Functions
      • Special Functions
        • Dynamic Columns Functions
        • Galera Functions
        • Geographic Functions
        • JSON Functions
          • JSONPath Expressions
          • Differences between JSON_QUERY and JSON_VALUE
          • JSON_ARRAY
          • JSON_ARRAYAGG
          • JSON_ARRAY_APPEND
          • JSON_ARRAY_INSERT
          • JSON_ARRAY_INTERSECT
          • JSON_COMPACT
          • JSON_CONTAINS
          • JSON_CONTAINS_PATH
          • JSON_DEPTH
          • JSON_DETAILED
          • JSON_EQUALS
          • JSON_EXISTS
          • JSON_EXTRACT
          • JSON_INSERT
          • JSON_KEY_VALUE
          • JSON_KEYS
          • JSON_LENGTH
          • JSON_LOOSE
          • JSON_MERGE
          • JSON_MERGE_PATCH
          • JSON_MERGE_PRESERVE
          • JSON_NORMALIZE
          • JSON_OBJECT
          • JSON_OBJECT_FILTER_KEYS
          • JSON_OBJECT_TO_ARRAY
          • JSON_OBJECTAGG
          • JSON_OVERLAPS
          • JSON_PRETTY
          • JSON_QUERY
          • JSON_QUOTE
          • JSON_REMOVE
          • JSON_REPLACE
          • JSON_SCHEMA_VALID
          • JSON_SEARCH
          • JSON_SET
          • JSON_TABLE
          • JSON_TYPE
          • JSON_UNQUOTE
          • JSON_VALID
          • JSON_VALUE
          • JSON Validation Function
        • Window Functions
      • String Functions
      • Vector Functions
    • Data Types
    • Plugins
    • System Tables
    • Error Codes
    • Client/Server Protocol
    • Product Development
Powered by GitBook
On this page

Was this helpful?

  1. Reference
  2. SQL Functions
  3. Special Functions

JSON Functions

Complete JSON Functions reference: JSON_EXTRACT(), JSON_SET(), JSON_REPLACE(), JSON_SEARCH() syntax for path queries, document updates, and value retrieval.

JSONPath ExpressionsDifferences between JSON_QUERY and JSON_VALUEJSON_ARRAYJSON_ARRAYAGGJSON_ARRAY_APPENDJSON_ARRAY_INSERTJSON_ARRAY_INTERSECTJSON_COMPACTJSON_CONTAINSJSON_CONTAINS_PATHJSON_DEPTHJSON_DETAILEDJSON_EQUALSJSON_EXISTSJSON_EXTRACTJSON_INSERTJSON_KEY_VALUEJSON_KEYSJSON_LENGTHJSON_LOOSEJSON_MERGEJSON_MERGE_PATCHJSON_MERGE_PRESERVEJSON_NORMALIZEJSON_OBJECTJSON_OBJECT_FILTER_KEYSJSON_OBJECT_TO_ARRAYJSON_OBJECTAGGJSON_OVERLAPSJSON_PRETTYJSON_QUERYJSON_QUOTEJSON_REMOVEJSON_REPLACEJSON_SCHEMA_VALIDJSON_SEARCHJSON_SETJSON_TABLEJSON_TYPEJSON_UNQUOTEJSON_VALIDJSON_VALUEJSON Validation Function
PreviousGeographic FunctionsNextJSONPath Expressions

Last updated 8 months ago

Was this helpful?

LogoLogo

Products

  • Enterprise Platform
  • Community Server
  • Download MariaDB
  • Pricing

Support

  • Customer Login
  • Technical Support
  • Remote DBA
  • Professional Services

Resources

  • MariaDB Blog
  • Webinars
  • Customer Stories
  • MariaDB Events
  • Documentation
  • Developer Hub

Company

  • About MariaDB
  • Newsroom
  • Leadership
  • MariaDB Careers
  • Legal
  • Privacy Policy

© 2026 MariaDB. All rights reserved.