MySQL LOCATE()
In SQL, the LOCATE() function is used to search for the position of a string in a record. The function
Read More
MySQL
MySQL LCASE()
The LCASE() function in SQL language allows you to transform all uppercase characters in a string into lowercase. This function
Read More
MySQL UCASE()
The UCASE() function in SQL language allows you to transform all lowercase characters in a string into uppercase. This function
Read More
MySQL String To Lowercase
The LOWER() function in SQL language allows you to transform all uppercase characters in a string into lowercase. This function
Read More
MySQL Uppercase in Where Clause
The UPPER() function in SQL language allows you to transform all lowercase characters in a string into uppercase. This function
Read More
MySQL Select Uppercase
The UPPER() function in SQL language allows you to transform all lowercase characters in a string into uppercase. This function
Read More
MySQL LPAD() With Leading Zeros
In SQL language, the LPAD() function allows to complete a string until it reaches the desired size, by adding characters
Read More
MySQL RTRIM()
In SQL language, the RTRIM() function allows you to delete characters at the end of a string. Most often the
Read More
MySQL LTRIM()
In SQL language, the LTRIM() function allows you to delete characters at the beginning of a string. Most often the
Read More
MySQL Trim Whitespace Using TRIM() Function
In SQL language, the TRIM() function allows you to delete characters at the beginning and end of a string. Most
Read More