mysql mid function

Extract a substring from a string (start at position 5, extract 3 characters):

SELECT MID("SQL Tutorial", 5, 3) AS ExtractString;

Definition and Usage

The MID() function extracts a substring from a string (starting at any position).

Note: The position of the first character in the string is 1.

1	2	3	4	5	6	7	8	9	10	11	12
S	Q	L		T	u	t	o	r	i	a	l

Note: The position of the last character in the string is -1.

-12	-11	-10	-9	-8	-7	-6	-5	-4	-3	-2	-1
S	Q	L		T	u	t	o	r	i	a	l

Note: The MID() and SUBSTR() functions equals the SUBSTRING() function. Continue reading MySQL MID Function

Convert the text to lower-case:

SELECT LCASE("SQL Tutorial is FUN!");

The LCASE() function converts a string to lower-case.

Note: The LOWER() function is a synonym for the LCASE() function.

LCASE(text)

Parameter	Description
text	Required. The string to convert

Works in:	From MySQL 4.0

Convert the text in “CustomerName” to lower-case:

SELECT LCASE(CustomerName) AS LowercaseCustomerName
FROM Customers;