Thinking about this further, SOUNDEX could possibly be a winner. Especially as MySQL has a SOUNDS LIKE expression. Run a SELECT for description SOUNDS LIKE search_clue OR search_clue SOUNDS LIKE description
Thread: Loosen Search Query
Results 1 to 10 of 13
Hybrid View
-
5 Dec 2007, 05:38 PM #1
Totally Zenned
- Join Date
- Sep 2007
- Location
- Dublin, Ireland
- Posts
- 1,288
- Plugin Contributions
- 8
Re: Loosen Search Query
-
5 Dec 2007, 09:45 PM #2
Sensei
- Join Date
- Jan 2004
- Posts
- 66,446
- Plugin Contributions
- 81
Re: Loosen Search Query
There could be some big challenges with multi-lingual sites when using that approach. Something to keep in mind as you research further.
Originally Posted by hem
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
5 Dec 2007, 11:09 PM #3
Totally Zenned
- Join Date
- Sep 2007
- Location
- Dublin, Ireland
- Posts
- 1,288
- Plugin Contributions
- 8
Re: Loosen Search Query
That's true- SOUNDEX only works on English. Plus it won't handle multi-byte either. Originally Posted by DrByte
Similar Threads
-
v151 Search - including or ignoring "and" as first keyword in search query
By nikerymis in forum General QuestionsReplies: 0Last Post: 27 Jan 2014, 08:44 PM -
search shows unrelated results for particular search query (both site and admin)
By dogbreed in forum General QuestionsReplies: 1Last Post: 25 Jan 2011, 02:05 PM -
Customize admin customer search query: search alt emails, too?
By Matt008 in forum All Other Contributions/AddonsReplies: 3Last Post: 15 Apr 2010, 01:10 AM -
Maintaining the user's search query in the advanced search box?
By arniesbarmyarmy in forum General QuestionsReplies: 0Last Post: 26 Feb 2010, 01:27 PM
