MySQL :: MySQL 5.0 Reference Manual :: 12.5 String Functions
expr1 SOUNDS LIKE expr2 This is the same as SOUNDEX(expr1) = SOUNDEX(expr2). SPACE(N) Returns a string consisting of N space characters. mysql> SELECT SPACE(6);-> ' ' SUBSTR(str,pos), SUBSTR(str FROM pos), ......