Search Is not displaying all results/Search with Dash (-)

[AZComp]

Hello,
My company sells parts which are often searched/sold by part number. Such as part # Q2425-69017 or RM1-0013. When we search for these with complete number we get no results. If we search by the portion after the - such as 0013 or 69017 we do get some results. This will not work for us...at all. Is there any suggestions as to what i can do to make this work?

http://www.azcomputing.biz/

Thanks in advance for your help!

[AZComp]

I am really at a loss here. Is there any search alternative?
Thanks

[Ajeh]

This should not be a problem if you have updated the:
/includes/modules/pages/advanced_search_results/header_php.php

correctly with the new field(s) you want included on the search ...

You should have added something on the where_str for the code:

        $where_str .= "(pd.products_name LIKE '%:keywords%'
                                         OR p.products_model
                                         LIKE '%:keywords%'
                                         OR m.manufacturers_name
                                         LIKE '%:keywords%'";

[AZComp]

This should not be a problem if you have updated the:
/includes/modules/pages/advanced_search_results/header_php.php

correctly with the new field(s) you want included on the search ...

You should have added something on the where_str for the code:

        $where_str .= "(pd.products_name LIKE '%:keywords%'
                                         OR p.products_model
                                         LIKE '%:keywords%'
                                         OR m.manufacturers_name
                                         LIKE '%:keywords%'";

I have to be honest I have no idea what you mean here...Should I put this in there? I am poor with php programming so I dont know if this is something I add in or should change. Further advise welcomed. I just want to be able to search for part #'s with - in the middle (not all part #'s have a - in middle but many do) like RM1-0013

[Ajeh]

You have added new fields to "some table" in your database or you have added new table(s) to your database ...

Where are these fields added?

How are they currently added to the search to be included in the search?

[AZComp]

This is on an out of the box install (or was when the search problem was not working. Search works it just does not factor in the -

[Ajeh]

You said ...

Such as part # Q2425-69017 or RM1-0013

What field in the products table are you using for the Part # ...

[AZComp]

The part # is in the item title or item description. I havnt added any fields/tables for this.

[Ajeh]

So far I cannot reproduce the problem ...

I add the same things to my product descriptions and have no problem on the search ...

I did find your search doesn't appear to work for anything ...

What happens if you switch to the Classic Template?

[AZComp]

The advanced search is not working right now as I am trying some things. The default template does the same thing. When I search for just 0013 I get results. When I search for rm1-0013 no results found.
Thanks!