minte9

LearnRemember   MYSQL

Left

Return a part from a string (php substr echivalent function)

 
SELECT LEFT('foobarbar', 5);
        -> fooba

Repeat

Returns a string repeated n times.

 
SELECT REPEAT('a', 3);
        -> aaa

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_left http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_repeat