MySQL string functions with query examples

MySQL string functions we can use to manipulate data and derive useful information and analysis from the tables. These functions can be used along with update commands to change records or can be used to update multiple tables.

If you have a table of your newsletter subscribers and you want to know how many are using gmail then you have to work on the email address and extract the domain part from it. You may also like it see the all the email providers in a single list with number of subscribers. Such applications are possible by using mysql string functions.

We will discuss some of the string functions and develop some applications using them.

Functions	Description
concat	Appending string data
CONVERT	Converting one data type to other
character_length	number of characters present in data
char_length	number of characters present in a string
ELT	Return the string based on position
FIELD	Return the position of the searched string
FIND_IN_SET	searching string within a set of strings
locate	searching the string & getting location of presence
Lower Upper case	Changing lower case to upper case and vies versa
Length	Length of the string in bytes
Left	Getting part of the string from left
LPAD	Pad string from Left
LTRIM	Remove blank space from Left
RTRIM	Remove blank space from Right
replace	Updating part of the data
Reverse	Reversing a string by Query
Repeat	Repeating string n number of times
RIGHT	Part of a string towards right
SPACE	Adding Space
strcmp	String Comparison
substring	Getting Part of the string
substring_index	Part of the string using delimiter
TRIM	Removing matching string from both ends of a string

Projects	Description
Domain , Userid	Updating table with Domain and Userid part of Email address
String Count	Counting presence of search string in a main string

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

String functions

Subhendu Mohapatra