Skip to Main Content
The world's most popular open source database
Contact MySQL  | 
Login  |  Register
  • MySQL.com
  • Downloads
  • Documentation
  • Developer Zone
Developer Zone Downloads MySQL.com
Documentation
  • MySQL Server
  • MySQL Enterprise
  • Workbench
  • InnoDB Cluster
  • MySQL NDB Cluster
  • Connectors
  • More
  • MySQL.com
  • Downloads
  • Developer Zone
Section Menu:  
Documentation Home
MySQL 9.7 Reference Manual
  • Preface and Legal Notices
  • General Information
  • Installing MySQL
  • Upgrading MySQL
  • Downgrading MySQL
  • Tutorial
  • MySQL Programs
  • MySQL Server Administration
  • Security
  • Backup and Recovery
  • Optimization
  • Language Structure
  • Character Sets, Collations, Unicode
  • Data Types
  • Functions and Operators
    • Built-In Function and Operator Reference
    • Loadable Function Reference
    • Type Conversion in Expression Evaluation
    • Operators
      • Operator Precedence
      • Comparison Functions and Operators
      • Logical Operators
      • Assignment Operators
    • Flow Control Functions
    • Numeric Functions and Operators
      • Arithmetic Operators
      • Mathematical Functions
    • Date and Time Functions
    • String Functions and Operators
      • String Comparison Functions and Operators
      • Regular Expressions
      • Character Set and Collation of Function Results
    • Full-Text Search Functions
      • Natural Language Full-Text Searches
      • Boolean Full-Text Searches
      • Full-Text Searches with Query Expansion
      • Full-Text Stopwords
      • Full-Text Restrictions
      • Fine-Tuning MySQL Full-Text Search
      • Adding a User-Defined Collation for Full-Text Indexing
      • ngram Full-Text Parser
      • MeCab Full-Text Parser Plugin
    • Cast Functions and Operators
    • XML Functions
    • Bit Functions and Operators
    • Encryption and Compression Functions
    • Locking Functions
    • Information Functions
    • Spatial Analysis Functions
      • Spatial Function Reference
      • Argument Handling by Spatial Functions