hankknight
asked on
PHP/mySQL Search: ignore spaces
I want to ignore spaces in my search.
So these would return the same results:
Hello World
and
helloworld
and
he llow orld
So these would return the same results:
Hello World
and
helloworld
and
he llow orld
SELECT
`name`, `description`, `p_street`, `p_city`
FROM
`organizations`
WHERE
`name` = 'helloworld'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I figured it out, thanks!
SELECT
`name`, `description`, `p_street`, `p_city`
FROM
`organizations`
WHERE
replace(`name`, ' ', '') LIKE '%elloworl%'
ASKER
Open in new window