all_functions_reference.txt

== Note: This file contains all valid function names that can be put in `functions.txt`. ==

== common functions ==
and
bit_count
bitand
bitneg
bitor
bitxor
case
cast
coalesce
div
eq
ge
getparam
getvar
greatest
gt
in
intdiv
interval
isfalse
isnull
istrue
le
least
leftshift
like
lt
minus
mod
mul
ne
not
nulleq
or
plus
regexp
rightshift
row
setvar
unaryminus
unaryplus
values
xor

== math functions ==
abs
acos
asin
atan
atan2
ceil
ceiling
conv
cos
cot
crc32
degrees
exp
floor
ln
log
log10
log2
pi
pow
power
radians
rand
round
sign
sin
sqrt
tan
truncate

== time functions ==
adddate
addtime
convert_tz
curdate
current_date
current_time
current_timestamp
curtime
date
date_add
date_format
date_sub
datediff
day
dayname
dayofmonth
dayofweek
dayofyear
extract
from_days
from_unixtime
get_format
hour
last_day
localtime
localtimestamp
makedate
maketime
microsecond
minute
month
monthname
now
period_add
period_diff
quarter
sec_to_time
second
str_to_date
subdate
subtime
sysdate
time
time_format
time_to_sec
timediff
timestamp
timestampadd
timestampdiff
to_days
to_seconds
unix_timestamp
utc_date
utc_time
utc_timestamp
week
weekday
weekofyear
year
yearweek

== string functions ==
ascii
bin
bit_length
char_func
char_length
character_length
concat
concat_ws
convert
elt
export_set
field
find_in_set
format
from_base64
hex
insert_func
instr
lcase
left
length
load_file
locate
lower
lpad
ltrim
make_set
mid
oct
octet_length
ord
position
quote
repeat
replace
reverse
right
rpad
rtrim
space
strcmp
substr
substring
substring_index
to_base64
trim
ucase
unhex
upper

== information functions ==
benchmark
charset
coercibility
collation
connection_id
current_role
current_user
database
found_rows
last_insert_id
row_count
schema
session_user
system_user
user
version

== control functions ==
if
ifnull
nullif

== miscellaneous functions ==
any_value
default_func
get_lock
inet6_aton
inet6_ntoa
inet_aton
inet_ntoa
is_free_lock
is_ipv4
is_ipv4_compat
is_ipv4_mapped
is_ipv6
is_used_lock
master_pos_wait
name_const
release_all_locks
release_lock
sleep
uuid
uuid_short

== encryption and compression functions ==
aes_decrypt
aes_encrypt
compress
decode
des_decrypt
des_encrypt
encode
encrypt
md5
old_password
password_func
random_bytes
sha
sha1
sha2
uncompress
uncompressed_length
validate_password_strength

== json functions ==
json_array
json_array_append
json_array_insert
json_contains
json_contains_path
json_depth
json_extract
json_insert
json_keys
json_length
json_merge
json_merge_patch
json_merge_preserve
json_object
json_pretty
json_quote
json_remove
json_replace
json_search
json_set
json_storage_size
json_type
json_unquote
json_valid