Result:
This command will load the contents of the Flowers.gif into the Picture column of the Products
table. The column must either be a BLOB or TEXT type column.
LOCATE(x, y, z)
Returns the position of the string x in string y starting at z. Returns 0 if it is not found.
Example:
SELECT LOCATE("M", "Mark", 2)
Result:
0
Example:
SELECT LOCATE("M", "Mark", 1)
Result:
1
LOG(x)
Returns the natural algorithm of the argument x.
Example:
LOG(5)
Result:
1.601438
Example:
LOG(-5)
Result:
NULL
LOG10(x)
Returns the base 10 algorithm of the argument.
Example:
LOG10(1000)
Result:
3
Example:
LOG10(-1000)
Result:
NULL
LOWER(x)
Returns the string x with all characters in lowercase. See LCASE(), UCASE(), and UPPER().
Example:
SELECT LOWER('MARK')
Result:
"mark"
LPAD(x, y, z)
Returns the string of x left padded with the string z until the length of the return string is equal to y. See
RPAD().
Example:
SELECT LPAD("Mark", 8, "OK")
Result:
"OKOKMark"
LTRIM(x)
Returns x without leading spaces. See RTRIM() and TRIM().
Example:
SELECT LTRIM(" Mark")