Database Reference
In-Depth Information
Return
type
Function name
Usage
ASCII(STRING str)
To return the numeric ASCII code of the first char-
acter
INT
CONCAT(STRING a,
STRING b..)
To return a single string representing all the argu-
ment values joined together
STRING
LENGTH(STRING s)
To return the length of characters in an argument
INT
REVERSE(STRING
a)
To return the reverse string of an argument
STRING
Besides these, there are many other string functions such as
FIND_IN_SET
,
INSTR
,
LOCATE
,
LOWER
,
UPPER
,
LTRIM
,
REPEAT
,
RTRIM
,
SUBSTR
,
TRANSLATE
,
TRIM
, and
UPPER
. Now, we can learn a few conditional functions, as described in the following
table:
Function name
Usage
Return type
CASE
An expression to get one or more possible values Argument
COALESCE
To return the first specified non
NULL
argument
Argument
