Mysql Tutorial

MySQL UCASE() Function The ucase() is a String function of MySQL. This function returns the string in upper case. Syntax select ucase(str)…

MySQL QUOTE() Function Quote(str) is a Sring function of MySQL. This method returns the string which is passed in single quote. Syntax…

MySQL UPPER() Function The upper() is a String function of MySQL. This function returns the string in upper case. Syntax select upper(str)…

MySQL REPEAT() Function REPEAT(str,count) is a Sring function of MySQL. This method returns the string reputation counter times. Syntax select repeat(str, count);…

MySQL String Function MySQL string functions manipulate the character string data effectively. The following table indicates each of the functions with a…

MySQL REPLACE() Function REPLACE(str,from_str,to_str) is a Sring function of MySQL. This method returns string from the given string to the string. Syntax…

MySQL LTRIM() Function LTRIM(str) is a Sring function of MySQL. This method returns string by removing leading space. Syntax select ltrim(str); Example…

MySQL SUBSTRING_INDEX() Function The substring_index() is a String function of MySQL. This function returns a substring from the given string(str) before the…

MySQL SIGN() Function The sign() is a Math function of MySQL. This function is used to get a sign of the given…

MySQL SIN() Function The sin() is a Math function of MySQL. This function is used to get the sine value of the…