Skip to content

Latest commit

 

History

History
13 lines (9 loc) · 893 Bytes

functions-and-operators-overview.md

File metadata and controls

13 lines (9 loc) · 893 Bytes
Raw
title summary aliases
Function and Operator Reference
Learn how to use the functions and operators.
/docs/dev/functions-and-operators/functions-and-operators-overview/
/docs/dev/reference/sql/functions-and-operators/reference/

Function and Operator Reference

The usage of the functions and operators in TiDB is similar to MySQL. See Functions and Operators in MySQL.

In SQL statements, expressions can be used on the ORDER BY and HAVING clauses of the SELECT statement, the WHERE clause of SELECT/DELETE/UPDATE statements, and SET statements.

You can write expressions using literals, column names, NULL, built-in functions, operators and so on. For expressions that TiDB supports pushing down to TiKV, see List of Expressions for Pushdown.