MySQL: String functions

I have been told by mentors and professors that the better way to learn it is to teach it to try someone else. In this case I’ll teach you something cool that I learned and it called Strings Functions but this time in MySQL, for those who don’t know what that is , it is a database management system which stands for “My”, the name of co-founder Michael Widenius’s daughter, and “SQL”, the abbreviation for Structured Query Language.

Strings Functions are used mainly use for string manipulations which mean you can basically play with it , within he String Functions we can find few that are very important like ASCII(),CONCAT(),LENGTH(),UPPER() and SUBSTR().

ASCII(str) is it a function that returns the ASCII value of the String in the parameter for example :

SELECT ASCII('A') FROM DUAL;

If we run this code the return value will be a column with the ascii value of string “A” which is is 65.

CONCAT(Str1,Str2) it is a function that returns a string which is the result of concatenating two or more arguments for example:

SELECT CONCAT('Life ','is ','beautiful ') from DUAL;

LENGTH(Str) this function will return the length of the given string for example:

SELECT LENGTH("Zawardo");

Upper(Str) this function will convert all characters within the given string to uppercase characters and then will return it for example:

SELECT UPPER("life");

SUBSTR(Str,Pos,Len) This function will return a specific number of character from a specific position of the given string for example:

SELECT SUBSTR("Beautiful",4,6);

These functions are very important when we want to add any change to our strings and these are not the only String functions that exits, there are few more and you can learn more about it here.