String Functions and Operators 2172 Name Description LPAD() Return the string argument, left-padded with the specified string LTRIM() Remove leading spaces MAKE_SET() Return a set of comma-separated strings that have the corresponding bit in bits set MATCH Perform full-text search MID() Return a substring starting from the specified position NOT LIKE Negation of simple pattern matching NOT REGEXP Negation of REGEXP OCT() Return a string containing octal representation of a number OCTET_LENGTH() Synonym for LENGTH() ORD() Return character code for leftmost character of the argument POSITION() Synonym for LOCATE() QUOTE() Escape the argument for use in an SQL statement 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 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 RPAD() Append string the specified number of times RTRIM() Remove trailing spaces SOUNDEX() Return a soundex string SOUNDS LIKE Compare sounds SPACE() Return a string of the specified number of spaces STRCMP() Compare two strings SUBSTR() Return the substring as specified SUBSTRING() Return the substring as specified SUBSTRING_INDEX() Return a substring from a string before the specified number of occurrences of the delimiter TO_BASE64() Return the argument converted to a base-64 string TRIM() Remove leading and trailing spaces