MySQL Query to return rows that contain whitespace
SELECT ...
...
WHERE username LIKE '% %'
INSTR() returns the position of the specified substring in the given string. Use it in the WHERE conditional.
SELECT * FROM table WHERE INSTR(`username`, ' ') > 0