how to match string with hyphens

[Anon]

Hi,

I have a table which contains a "model #" field. These model numbers are usually something like:

AR-210
AR-335N

etc.

Now I have a search on my site which searches by part number. Suppose the person enters:

AR210

Then the result does NOT show up because i'm using a LIKE syntax:

SELECT * FROM table WHERE model LIKE '%$query%'

where $query is the search text.

Is there any way I can add a REGEXP or something like that which will eliminate hyphens, whitespaces, etc from the table data while searching for the match?

I thought of using SOUNDEX or something like that. Will that do the trick? If so, won't it be very slow (i have over 2000 entries in the table)

thanks!!
-sridhar

[[deleted]]

Try something like :

SELECT * FROM table WHERE REPLACE(model,'-','') LIKE '%$query%'

Matt Wade
http://codewalkers.com