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
Functions That Create Geometry Values from WKT Values
Functions That Create Geometry Values from WKB Values
MySQL-Specific Functions That Create Geometry Values
Geometry Format Conversion Functions
Geometry Property Functions
General Geometry Property Functions
Point Property Functions
LineString and MultiLineString Property Functions
Polygon and MultiPolygon Property Functions
GeometryCollection Property Functions
Spatial Operator Functions
Functions That Test Spatial Relations Between Geometry Objects
Spatial Relation Functions That Use Object Shapes
Spatial Relation Functions That Use Minimum Bounding Rectangles
Spatial Geohash Functions
Spatial GeoJSON Functions
Spatial Aggregate Functions
Spatial Convenience Functions
JSON Functions
JSON Function Reference