18
18
Summary of Functions
19
19
--------------------
22
'TODO' "regular functions" ...there are no regular or irregular functions!!!
21
24
Comparative and regular functions
22
25
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
24
27
=================== ====================================================================================================
25
28
Operator Description
26
29
=================== ====================================================================================================
27
LIKE Matches a simple pattern
28
NOT LIKE Negation of simple pattern matching
29
STRCMP() Compare two strings
30
NOT REGEXP Negation of REGEXP
31
REGEXP Returns values that match a regular expression pattern
32
RLIKE Synonym for REGEXP
33
36
=================== ====================================================================================================
38
41
=================== ====================================================================================================
39
42
Operator Description
40
43
=================== ====================================================================================================
41
ASCII() Return numeric value of left-most character
42
BIN() Return a string representation of the argument
43
CHAR() Return the character for each integer passed
44
HEX() Return a hexadecimal representation of a decimal or string value
45
LOWER() Return the argument in lowercase
46
LCASE() Synonym for LOWER()
47
UCASE() Synonym for UPPER()
48
UNHEX() Convert each pair of hexadecimal digits to a character
49
UPPER() Convert to uppercase
50
53
=================== ====================================================================================================
55
58
=================== ====================================================================================================
56
59
Operator Description
57
60
=================== ====================================================================================================
58
BIT_LENGTH() Return length of argument in bits
59
CHAR_LENGTH() Return number of characters in argument
60
LENGTH() Return the length of a string in bytes
61
OCTET_LENGTH() A synonym for LENGTH()
62
65
=================== ====================================================================================================
67
70
=================== ====================================================================================================
68
71
Operator Description
69
72
=================== ====================================================================================================
70
CONCAT() Returns a concatenated string
71
TRIM() Remove leading and trailing spaces
72
LTRIM() Remove leading spaces
73
RTRIM() Remove trailing spaces
74
77
=================== ====================================================================================================
80
83
=================== ====================================================================================================
81
84
Operator Description
82
85
=================== ====================================================================================================
83
FIELD() Return the index (position) of the first argument in the sequent arguments
84
FIND_IN_SET() Return the index position of the first argument within the second argument
85
INSTR() Return the index of the first occurrence of substring
86
LEFT() Return the leftmost number of characters as specified
87
INSERT() Insert a substring at the specified position up to the specified number of characters
88
LOCATE() Return the position of the first occurrence of substring
89
POSITION() A synonym for LOCATE()
90
93
=================== ====================================================================================================
96
99
=================== ====================================================================================================
97
100
Operator Description
98
101
=================== ====================================================================================================
99
ELT() Return string at index number
100
EXPORT_SET() Return a string
101
FORMAT() Return a number formatted to specified number of decimal places
102
LOAD_FILE() Load the named file
103
LPAD() Return the string argument, left-padded with the specified string
104
MAKE_SET() Return a set of comma-separated strings that have the corresponding bit in bits set
105
MATCH Perform full-text search
106
MID() Return a substring starting from the specified position
107
ORD() Return character code for leftmost character of the argument
108
QUOTE() Escape the argument for use in an SQL statement
109
REPEAT() Repeat a string the specified number of times
110
REPLACE() Replace occurrences of a specified string
111
REVERSE() Reverse the characters in a string
112
RIGHT() Return the specified rightmost number of characters
113
RPAD() Append string the specified number of times
114
SOUNDEX() Return a soundex string
115
SUBSTR() Return the substring as specified
116
SUBSTRING_INDEX() Return a substring from a string before the specified number of occurrences of the delimiter
117
SUBSTRING() Return the substring as specified
118
121
=================== ====================================================================================================