Webinar | Modernizing High-Volume Payment Systems: Real-Time Architecture and Demo
Register Now
LogoLogo
⌘Ctrlk
Download MariaDBContact Us
  • Home
  • MariaDB Platform
  • Server
  • MaxScale
  • Analytics
  • Galera Cluster
  • Connectors
  • Tools
  • MariaDB Cloud
  • Release Notes
  • General Resources
LogoLogo
  • 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
For the complete documentation index, see llms.txt. This page is also available as Markdown.
ChatGPT
  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 1 year 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.

Was this helpful?