Znakové (textové) funkce


Name


ASCII()


BIN()


BIT_LENGTH()


CHAR()


CHAR_LENGTH()


CHARACTER_LENGTH()


CONCAT()


CONCAT_WS()


ELT()


EXPORT_SET()


FIELD()


FIND_IN_SET()


HEX()


INSERT()


INSTR()


LCASE()    LOWER()


LEFT()


LENGTH()


LIKE


LOCATE()


LPAD()


LTRIM()


MATCH


MID()


NOT LIKE


NOT REGEXP


OCT()


ORD()


POSITION()


REGEXP


REPEAT()


REPLACE()


REVERSE()


RIGHT()


RLIKE


RPAD()


RTRIM()


SOUNDEX()


SOUNDS LIKE


SPACE()


STRCMP()


SUBSTR()SUBSTRING()


SUBSTRING_INDEX()


TRIM()


UCASE()  UPPER()


UNHEX()


Syntaxe


CONCAT_WS (separator, string1, string2, ...)


ELT(index number, string1, string2, string3,…)


FIELD(search string, string1, string2, string3…..)


FIND_IN_SET (search string, string list)


INSERT (ori_string, in_pos, length, new_string)


INSTR (ori str, substr)


LPAD(str, len, padstr)


MID (str, pos, len)


POSITION (substr IN str)


REPEAT (str, count)


REPLACE (str, find_string, replace_with)


STRCMP (expr1, expr2)


SUBSTR (str, pos, len)