MySQL LCASE() Function LCASE(str) is a Sring function of MySQL. This method returns string in lower case. Syntax select lcase(‘TUTORASPIRE’); Example 1…
Tag:
insert
-
-
LCASE Function in SQL This string function shows all the string characters in the lower case in Structured Query Language. It converts…
-
MySQL LOCATE() Function LOCATE(substr,str) is a Sring function of MySQL. This method returns the first occurrence of given substr in the given…
-
MySQL RTRIM() Function The Rtrim() is a String function of MySQL. This method removes the extra space if present in the tail…
-
MySQL SOUNDEX() Function The Soundex() is a String function of MySQL. This method returns a Soundex string. Two strings which sound almost…
-
Python sorted() Function Python sorted() function is used to sort elements. By default, it sorts elements in ascending order but can be…
-
MySQL ELT() Function Elt() function is a Sring function of MySQL. This method Nth element from the list of string. Syntax select…
-
MySQL SUBSTR() Function The substr() is a String function of MySQL. This function returns the substring from the given string. Syntax select…
-
Python hash() Function Python has() function is used to get the hash value of an object. Python calculates the hash value by…
-
MySQL SUBSTRING() Function The substring() is a String function of MySQL. This function returns the substring from the given string. Syntax select…