Built-In Function and Operator Reference Name Description Introduced Deprecated PS_THREAD_ID() Performance Schema thread ID for given thread 8.0.16 QUARTER() Return the quarter from a date argument QUOTE() Escape the argument for use in an SQL statement RADIANS() Return argument converted to radians RAND() Return a random floating- point value RANDOM_BYTES() Return a random byte vector RANK() Rank of current row within its partition, with gaps REGEXP Whether string matches regular expression REGEXP_INSTR() Starting index of substring matching regular expression REGEXP_LIKE() Whether string matches regular expression REGEXP_REPLACE() Replace substrings matching regular expression REGEXP_SUBSTR() Return substring matching regular expression RELEASE_ALL_LOCKS() Release all current named locks RELEASE_LOCK() Release the named lock REPEAT() Repeat a string the specified number of times REPLACE() Replace occurrences of a specified string REVERSE() Reverse the characters in a string RIGHT() Return the specified rightmost number of characters RLIKE Whether string matches regular expression ROLES_GRAPHML() Return a GraphML document representing memory role subgraphs 2108