MySQL - String Functions
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. |