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.
|concat||Appending string data|
|substring||Getting Part of the string|
|substring_index||Part of the string using delimiter|
|Data length||number of characters present in data|
|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 our record|
|Left||Getting part of the string from left|
|LPAD||Pad string from Left |
|replace||Updating part of the data|
|Reverse||Reversing a string by Query|
|Repeat||Repeating string n number of times|
|RPAD||Pad string from Right|
Be the first to post comment on this article :