”;
MySQL – String Functions
MySQL string functions are used to manipulate the string values. The following table details the string functions that are available in the MySQL.
Sr.No. | Name & Description |
---|---|
1 | ASCII()
This function returns numeric value of left-most character. |
2 | BIN()
This function returns a string representation of the argument. |
3 | BIT_LENGTH()
This function returns length of argument in bits. |
4 | CHAR()
This function returns the character for each integer passed. |
5 | CHAR_LENGTH()
This function returns number of characters in argument. |
6 | CHARACTER_LENGTH()
This function is a synonym for CHAR_LENGTH(). |
7 | CONCAT()
This function returns concatenated string. |
8 | CONCAT_WS()
This function returns concatenate with separator. |
9 | ELT()
This function returns string at index number. |
10 | EXPORT_SET()
This function returns a string such that for every bit set in the value bits, you get an on string and for every unset bit, you get an off string. |
11 | FIELD()
This function returns the index (position) of the first argument in the subsequent arguments. |
12 | FIND_IN_SET()
This function returns the index position of the first argument within the second argument. |
13 | FROM_BASE64()
This function decodes a base-64 encoded string as a binary string. |
14 | INSERT()
Inserts a substring at the specified position up to the specified number of characters. |
15 | INSTR()
This function returns the index of the first occurrence of substring. |
16 | LCASE()
Synonym for LOWER(). |
17 | LEFT()
This function returns the leftmost number of characters as specified. |
18 | LENGTH()
This function returns the length of a string in bytes. |
19 | LOAD_FILE()
This function is used to load the specified file. |
20 | LOCATE()
This function returns the position of the first occurrence of substring. |
21 | LOWER()
This function returns the argument in lowercase. |
22 | LPAD()
This function returns the string argument, left-padded with the specified string. |
23 | LTRIM()
This function is used to removes leading spaces from the given string. |
24 | MAKE_SET()
This function returns a set of comma-separated strings that have the corresponding bit in bits set. |
25 | MID()
This function returns a substring starting from the specified position. |
26 | OCT()
This function returns a string representation of the octal argument. |
27 | OCTET_LENGTH()
This function is a synonym for LENGTH(). |
28 | ORD()
If the leftmost character of the argument is a multi-byte character, returns the code for that character. |
29 | POSITION()
This function is a synonym for LOCATE(). |
30 | QUOTE()
This function escapes the argument for use in an SQL statement. |
31 | REPEAT()
This function returns the starting index of the substring matching given regular expression. |
32 | REPLACE()
This function replaces the matched sub string with the replacement string and returns the result. |
33 | REVERSE()
This function is used to reverse the characters in a string |
34 | RIGHT()
This function returns the specified rightmost number of characters. |
35 | RPAD()
This function is used to add padding to the right side of the string until it reaches the desired length. |
36 | RTRIM()
This function is used to remove trailing spaces. |
37 | SOUNDEX()
This function returns a soundex string. |
38 | SPACE()
This function returns a string of the specified number of spaces. |
39 | STRCMP()
This function is used to compare two given strings. |
40 | SUBSTR()
This function returns the substring as specified. |
41 | SUBSTRING()
This function returns the substring as specified. |
42 | SUBSTRING_INDEX()
This function returns a substring from a string before the specified number of occurrences of the delimiter. |
43 | TO_BASE64()
This function encodes a string value to base-64 string. |
44 | TRIM()
This function is used to removes the leading and trailing spaces of the given string. |
45 | UCASE()
This function is a synonym for UPPER(). |
46 | UNHEX()
This function converts each pair of hexadecimal digits to a character. |
47 | UPPER()
This function is used to convert the characters in the given string to uppercase. |
48 | WEIGHT_STRING()
This function returns the weight string value of the given argument. |
49 | MATCH
This operator is used to search for particular string in the specified list of columns. |
50 | REGEXP
This operator is similar to the REGEXP_LIKE() function it is used to match a particular pattern in the given string. |
51 | SOUNDS LIKE
This operator is used to compare the soundex values of two strings. |
”;