query: SHOW FUNCTIONS
!
%
&
&&
*
+
-
/
<
<=
<>
=
==
>
>=
^
abs
acos
and
ascii
asin
avg
bigint
bin
boolean
case
ceil
ceiling
coalesce
concat
conv
cos
count
date_add
date_sub
datediff
day
dayofmonth
div
double
elt
exp
float
floor
from_unixtime
get_json_object
hash
hex
if
index
instr
int
isnotnull
isnull
lcase
length
like
ln
locate
log
log10
log2
lower
lpad
ltrim
max
min
month
negative
not
or
parse_url
pmod
positive
pow
power
rand
regexp
regexp_extract
regexp_replace
repeat
reverse
rlike
round
rpad
rtrim
sin
size
smallint
space
split
sqrt
std
stddev
stddev_pop
stddev_samp
string
substr
substring
sum
tinyint
to_date
trim
ucase
unix_timestamp
upper
var_pop
var_samp
variance
when
year
|
||
~
query: SHOW FUNCTIONS '^c.*'
case
ceil
ceiling
coalesce
concat
conv
cos
count
query: SHOW FUNCTIONS '.*e$'
case
coalesce
double
from_unixtime
lcase
like
locate
negative
positive
regexp_replace
reverse
rlike
size
space
to_date
ucase
variance
query: SHOW FUNCTIONS 'log.*'
log
log10
log2
query: SHOW FUNCTIONS '.*date.*'
date_add
date_sub
datediff
to_date
query: SHOW FUNCTIONS '***'