MySQL trim function
MySQL TRIM() function returns a string after removing all prefixes or suffixes from the given string. Syntax TRIM([{BOTH | LEADING
Read more
mysql string function
MySQL RAND Function
MySQL has a RAND function that can be invoked to produce random numbers between 0 and 1: mysql> SELECT RAND(
Read more mysql locate function
MySQL LOCATE() returns the position of the first occurrence of a string within a string. Both of these strings are
Read more mysql concat function
MySQL CONCAT function is used to concatenate two strings to form a single string. Description: MySQL CONCAT() function is used
Read more MySQL substring function
MySQL SUBSTRING() returns a specified number of characters from a particular position of a given string. Syntax: SUBSTRING(str, pos, len)
Read more