MySQL String Functions
MySQL string functions and descriptions of their uses.
Download optionsThe records
10 of 33 records · Select a column heading to sort.
| 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 |
Free sample files (up to 10 rows): CSV JSON XML
Scope and sources
Last checked against sources: October 15, 2026.
Last changed: July 17, 2026. This is when we last changed the data or its description. It doesn’t mean the data runs up to that date.
A complete download includes all 33 records currently held in this dataset. Check the description and sources to decide whether its scope fits your project.
Use this dataset through the API
GET https://mysafeinfo.com/api/data/mysqlstringfunctionsChoose a format, sort, or request fewer rows. A pass key gives access to the complete dataset. See the examples and parameters.
Without a pass, sorting and randomization apply only to the fixed 10-row sample.