Product Searcher

[alfoxy]

Hi All,

I have a product database in MySQL.

Some of the products are duplicated between different manufacturers
e.g.

ID Manufacturer
HK 1212 SKF
HK1212 NSK
HK1212 RS NSK
HK 1212 ZZ SKF

As you can see the two codes are the same except for the spaces.

I want people to be able to enter the search phrases with or without the spaces
e.g.
"HK1212" or "HK 1212" would return all 4 results
"HK1212ZZ" or "HK 1212 ZZ" would return the 4th item

Any suggestions would be gratefully appreciated.

P.s. I cant remove the spaces from the database as they are needed to link to a second database.

Thanks

Al

[NogDog]

How about:

$sql = "SELECT......WHERE REPLACE(column_name, ' ', '') = REPLACE('$search', ' ', '')";

[alfoxy]

Many Thanks,

That works perfectly, Just one more question ... how would I use the REPLACE function if I want to use LIKE instead of =.

E.g.

"SELECT .... WHERE column_name LIKE '%".$search_name."%'";

Al