Query that ignore the spaces.
- by xRobot
What's the best way to run a query so that spaces in the fields are
ignored? For example the following queries....
SELECT * FROM mytable WHERE username = "JohnBobJones"
SELECT * FROM mytable WHERE username = "John Bob Jones"
.
would find the following entries:
John Bob Jones
JohnBob Jones
JohnBobJones
.
I am using php or python but I think this doesn't matter.