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

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")