I use the following mySQL query to find fields regardless of spaces.
Now I want to do this for ALL non alphanumeric characters, not just spaces. So things like ' and " and _ should be replaced as well.
`name`, `description`, `p_street`, `p_city`
replace(`name`, ' ', '') LIKE '%elloworl%'