Include numbers in Search (Problem?)

[FlodaParticipant]

Hi there,

I’ve a problem with the search for numbers (it seems to be a numbers problem). I have a search for custom post types (“produkt”) and need to find specific posts of that post type by a number (CAS-Nr.). So I set up a search for that specific post type. The post which should be found is named/titled “Acrylol Chloride (CAS-Nr.: 814-68-6)”. If I search for “Acrylol” the search works perfectly, but I also need to search by CAS-Nr. So if I search for “814-68-6” I got no results.

Could you help me with this? I think I just missed a configuration but I can’t find it.

Find the sample search-page here:
http://www.blitzfaenger-agentur-kunden.de/sp_chemicals/?page_id=617
The sample post is here:
http://www.blitzfaenger-agentur-kunden.de/sp_chemicals/?produkt=acrylol-chloride-cas-nr-814-68-6

the login details for access attached.

Thanks a lot
Florian Danner

• This topic was modified 8 years, 4 months ago by  Floda.

[FlodaParticipant]

–

• This reply was modified 8 years, 4 months ago by  Floda.

[Ernest MarcinkoKeymaster]

Hi!

Thank you for the detailed ticket. I found the issue immediately. It was the fulltext search. MySQL fulltext search has this “feature” where it ignores common words and stuff. I guess that numbers are no exception, so the database just simply ignored the numbers in the search term. I turned off the fulltext options under the “Fulltext search settings” submenu. It should work properly now.

Best,
Ernest Marcinko
If you like my products, don't forget to rate them on codecanyon :)

[FlodaParticipant]

Hi Ernest

wow! that was fast and it works perfectly. thank you very much for the great support!

Best
Florian

[Author]

Posts