Webinar | The New MariaDB Enterprise Platform for Agentic AI, Analytics, and Cloud
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_ARRAY_APPEND
          • JSON_ARRAY_INSERT
          • JSON_ARRAY_INTERSECT
          • JSON_ARRAYAGG
          • 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
        • Window Functions
      • String Functions
      • Vector Functions
    • Data Types
    • Plugins
    • System Tables
    • Error Codes
    • Client/Server Protocol
Powered by GitBook
On this page

Was this helpful?

  1. Reference
  2. SQL Functions
  3. Special Functions

JSON Functions

Explore JSON functions in MariaDB Server. This section details SQL functions for creating, manipulating, and querying JSON data, enabling flexible and efficient handling of unstructured data.

JSONPath ExpressionsDifferences between JSON_QUERY and JSON_VALUEJSON_ARRAYJSON_ARRAY_APPENDJSON_ARRAY_INSERTJSON_ARRAY_INTERSECTJSON_ARRAYAGGJSON_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_VALUE

Last updated 4 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

© 2025 MariaDB. All rights reserved.