Query that ignore the spaces

August 13, 2023 by Tarik

SELECT * FROM mytable 
    WHERE REPLACE(username, ' ', '') = REPLACE("John Bob Jones", ' ', '')