Microsoft Word - Sam's Teach Yourself MySQL in 21 Days - SAMS.doc

(singke) #1
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")

Free download pdf