MySQL Functions on Character String Values

Q

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

A

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

ELT() - String at Given Index

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

INSTR() - Find Substring

LCASE() - Synonym for LOWER()

LEFT() - First N Characters

LENGTH() - Number of Bytes in String

LOCATE() - Locate Substring Starting at N

LOWER() - Convert String to Lower Case

LPAD() - Left-Padding String

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

REPEAT() - Repeating String

REPLACE() - Replacing Substring

REVERSE() - Reversing String

RIGHT() - Last N Characters

RPAD() - Right-Padding String

RTRIM() - Right-Trimming String

SOUNDEX() - Soundex Encoding

SPACE() - Repeating Space Character

STRCMP() - Comparing Strings

SUBSTR() - Synonym for SUBSTRING()

SUBSTRING() - Substring at Given Position

SUBSTRING_INDEX() - Substring in Delimited String

TO_BASE64() - Base64 Encoding

TRIM() - Trimming String

UCASE() - Synonym for UPPER()

UNHEX() - HEX to String Conversion

UPPER() - Convert String to Upper Case

WEIGHT_STRING() - String Sorting Weight

⇒ ASCII() - ASCII Value of First Character

⇐ Aggregate Functions

⇑⇑ MySQL Function References

2023-11-10, 1953🔥, 0💬

dba.FYIcenter.com Links
Collections: Interview Questions MySQL Tutorials MySQL Functions Oracle Tutorials SQL Server Tutorials Transact-SQL Tutorials DBA Articles Site Map Other Resources: SQA (Software QA) Developer Resources DBA Resources Windows Tutorials Java JAR Files DLL Files File Extensions Security Certificates Re... 2025-03-17, 7753🔥, 0💬

How do I call MySQL SP from oracle using HS link ?
How do I call MySQL Stored Procedure from oracle using HS link ? HS link is correct and I can get the tables data just by adding '@' at the end of the table name ,but I can't call the SP same way ! Help please. 2022-01-24, 4220🔥, 0💬

"DROP USER" - Deleting a Database User in SQL Server
How To Delete an Existing Database User in SQL Server? If you don't want to keep a database user any more, you should delete the user by using the "DROP USER" statement. This tutorial exercise shows how to delete "Dba_User": -- Login with "sa" USE FyiCenterData; GO DROP USER Dba_User; GO -- List all... 2022-01-24, 3136🔥, 0💬

MS SQL Server DBA Checklist - General DBA Best Practices
-- Join (or start) a local SQL Server users group -- Attend at least one professional conference each year. -- Attend at least one training session each year. -- Read at least four books on SQL Server each year. -- Read the free e-book, How to Become an Exceptional DBA -- Learn everything you can ab... 2022-01-24, 2559🔥, 0💬

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. Here is a collection of reference information and tutorials on MySQL database functions on string values comp... 2023-11-10, 1954🔥, 0💬

Calling MySQL Built-in Functions
Where to find answers to frequently asked questions about calling MySQL Built-in Functions? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com team about calling MySQL Built-in Functions: Function Name Case Insensitive Function Argument Modifier Variable Number ... 2023-11-14, 1736🔥, 0💬

SQRT() - Square Root of X
How to calculate the square root of a given number using the SQRT() function? SQRT(X) is a MySQL built-in function that calculates the square root of a given number. For example: SELECT SQRT(2), SQRT(4), SQRT(8); -- +--------------------+-------- -+--------------------+-- | SQRT(2) | SQRT(4) | SQRT(... 2023-11-14, 1501🔥, 0💬

TRUNCATE() - Truncating to Decimal Place
How to truncate a value to a given decimal place using the TRUNCATE() function? TRUNCATE(X, D) is a MySQL built-in function that truncates X to decimal place of D. For example: SELECT TRUNCATE(-1.58, 0), TRUNCATE(23.298, 1), TRUNCATE(23.298, -1); -- +--------------------+-------- -------------+------... 2023-11-14, 1406🔥, 0💬

UPPER() - Convert String to Upper Case
How to convert a string to upper case using the UPPER() function? UPPER(str) is a MySQL built-in function that converts all characters of a given into upper case characters. For example: SET @str = 'dba.FYIcenter.com'; SELECT UPPER(@str); -- +-------------------+ -- | UPPER(@str) | -- +-------------... 2023-11-13, 1390🔥, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.