Collections:
MySQL Functions on Character String Values
Where to find reference information and tutorials on MySQL database functions on string values? I want to know how to use SUBSTRING(), REPLACE() and other character string related functions.
✍: FYIcenter.com
Here is a collection of reference information and tutorials on MySQL database functions on string values compiled by FYIcenter.com DBA team.
ASCII() - ASCII Value of First Character
BIT_LENGTH() - Number of Bits in String
CHAR() - Building String from Byte Values
CHAR_LENGTH() - Number of Characters
CHARACTER_LENGTH() - Synonym for CHAR_LENGTH()
CHARSET() - Detecting Character Set Name
COERCIBILITY() - Character Collation Coercibility
COLLATION() - Detecting Character Collation Name
CONCAT() - Concatenating Strings
CONCAT_WS() - Concatenation with Separator
CONV() - Binary/HEX String and Integer Conversion
FIELD() - Find String in String List
FIND_IN_SET() - Find Substring in List String
FROM_BASE64() - Base64 Decoding
HEX() - Calculate HEX representation
INSERT() - Insert and Replace Substring
LENGTH() - Number of Bytes in String
LOCATE() - Locate Substring Starting at N
LOWER() - Convert String to Lower Case
LTRIM() - Left-Trimming String
MID() - Synonym for SUBSTRING()
OCT() - Calculate Octal representation
OCTET_LENGTH() - Synonym for LENGTH()
ORD() - Order Value of First Character
POSITION() - Synonym for LOCATE()
QUOTE() - MySQL Quoting String
REPLACE() - Replacing Substring
RTRIM() - Right-Trimming String
SPACE() - Repeating Space Character
SUBSTR() - Synonym for SUBSTRING()
SUBSTRING() - Substring at Given Position
SUBSTRING_INDEX() - Substring in Delimited String
UNHEX() - HEX to String Conversion
2023-11-10, 312🔥, 0💬
Popular Posts:
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...