MySQL Tutorial

Define MySQL

MySQL Create Database

MySQL Create Table

MySQL Constraints

MySQL Case Sensitivity

MySQL Insert

MySQL Select

MySQL Data Types

MySQL OrderBy

MySQL Top

MySQL Distinct

MySQL Update

MySQL Delete

MySQL Truncate

MySQL Drop

MySQL Alter

MySQL Join

MySQL Aggregate Function

MySQL String Function

MySQL Date Function

Page Stats

Visitor: 283

MySQL String Functions

SQL string functions perform operation on a string input value and return a string or numeric value. The following table list some useful string functions:

FunctionDescription
CONCAT()Returns a string by concatenating two or more string values.
LOWER()Converts a string to lowercase.
UPPER()Converts a string to uppercase.
SUBSTRING()Returns a substring from string.
REVERSE()Returns the reverse order of a string value.
TRIM()Remove leading and trailing spaces from a string.