LOWER(),LCASE(),UPPER() & UCASE String functions in SQL/MySQL||MySQL Tutorial Series||Code With Neha
In my previous video of MySQL series I have discussed about CONCAT AND CONCAT_WS String functions
You can check the video from above i button
Today I will be discussing about LOWER(),LCASE() UPPER () AND UCASE() String function in MySQL
So without any delay let's get started
MySQL LOWER() Function
The LOWER() function converts a string to lower-case.
Syntax
LOWER(text)
LCASE() and LOWER() are generally the same in SQL, but their availability depends on the specific database system you are using.
Functionality: Both functions convert a string to all lowercase characters. They do not affect numeric values, special characters, or characters that are already in lowercase
MySQL UPPER() Function
The UPPER() function converts a string to upper-case.
Note: This function is equal to the UCASE() function.
Syntax
UPPER(text)
So that's it for today
WE will discuss more string functions in my upcoming videos
Hope you all will get some help from this video
If it's so then don't forget to subscribe my channel Code with Neha and press the Bell Icon for Regular Updates
See you in the next video till then Stay Safe Stay Happy
#mysql
#mysql_workbench
#mysql8
#mysqlserver
#mysqldba
#mysqltutorials
#mysqldb
#mysqldatabase
#sql
#sqlbasics
#sqlserver
#sqlfunctions
#sqlfundamentals
#sqlstringfunctions
#ascii
#ASCIISTRING
#ASCIISTRINGFUNCTIONS
#mysqltutorialforbeginners
#sqltutorialforbeginners
#strings
#stringfunctions
#stringfunctionsinsql
#stringfunctionsinmysql
#mysqlstringfunction
#sqlstringfunction
#lowercasestring
#lowercasestringfunction
#uppercasestring
#uppercasestringfunction
#lcasestring
#lcasestringfunction
#ucasestring
#ucasestringfunction