One way is to remove the blanks from the data using REPLACE. For example:
SELECT * FROM mytable WHERE REPLACE(username, ' ', '') = "JohnBobJones"
The same can be done for other characters so if you also want to remove the hyphen then
SELECT * FROM mytable WHERE REPLACE( REPLACE(username, ' ', ''), '-', '') = "JohnBobJones"