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