MySafeInfo

MySQL String Functions

Technology 33 records updated 2026-07-17

MySQL String Functions, with function, and description.

Get this data

GET https://mysafeinfo.com/api/data/mysqlstringfunctions

JSON XML CSV Download CSV

Sort, page, randomize, and download with query parameters; see the documentation.

Try it live

Run a request against mysqlstringfunctions straight from your browser. Add your API key to lift the row cap and return every record. The call goes to the API and nothing is stored here.

Preview

First 25 of 33 records. Click a column to sort these rows.

ID Function Description
1 ASCII Returns the ASCII value for the specific character
2 CHAR_LENGTH Returns the length of a string (in characters)
3 CHARACTER_LENGTH Returns the length of a string (in characters)
4 CONCAT Adds two or more expressions together
5 CONCAT_WS Adds two or more expressions together with a separator
6 FIELD Returns the index position of a value in a list of values
7 FIND_IN_SET Returns the position of a string within a list of strings
8 FORMAT Formats a number to a format like "#,###,###.##", rounded to a specified number of decimal places
9 INSERT Inserts a string within a string at the specified position and for a certain number of characters
10 INSTR Returns the position of the first occurrence of a string in another string
11 LCASE Converts a string to lower-case
12 LEFT Extracts a number of characters from a string (starting from left)
13 LENGTH Returns the length of a string (in bytes)
14 LOCATE Returns the position of the first occurrence of a substring in a string
15 LOWER Converts a string to lower-case
16 LPAD Left-pads a string with another string, to a certain length
17 LTRIM Removes leading spaces from a string
18 MID Extracts a substring from a string (starting at any position)
19 POSITION Returns the position of the first occurrence of a substring in a string
20 REPEAT Repeats a string as many times as specified
21 REPLACE Replaces all occurrences of a substring within a string, with a new substring
22 REVERSE Reverses a string and returns the result
23 RIGHT Extracts a number of characters from a string (starting from right)
24 RPAD Right-pads a string with another string, to a certain length
25 RTRIM Removes trailing spaces from a string

Notes