Learn SQL Database Programming

String built-in functions

String built-in functions allow you to manipulate string values. There are many different string functions. The commonly used string built-in functions are shown in the following list. Note that each of them can be used with a string value, a column with string values, or an expression that contains strings:

• CHAR_LENGTH: This returns the length of a string in characters.
• CHAR_LENGTH('string'): This will return 6 since it's counting the number of characters in the string.
• CHAR_LENGTH(column1): This will return the string length in characters for the values in column1 for each row.
• LENGTH : This returns the length of a string in bytes.
• LENGTH('string'): This will return 6 since it's the length in bytes.
• CONCAT ...