Jump to content


Photo

SOUNDEX search engine - how to do it ?


  • Please log in to reply
No replies to this topic

#1 BennySHS

BennySHS
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 18 October 2005 - 12:11 PM

Hi there!

i'm relative new to mysql, and I'm trying the first time to realize a search engine with soundex-support (to find similar sounding words)

But I'm stuck...my problem:

I got a table with firms/concerns.

It looks like this (not exactly...):

id | companyname | adress | description | search_words ....


My problem:
The search_words - fields contains some words like "car engine tires leatherseats tuning", perhaps some more.

Is there any way to search the search_words field with soundex, or must i create another table with search_words, where every word has its own entry ?
(I guess I need to do this, but before I do i wanted to ask you if there's another/better way to do this.)

thx in advance,
greets ben




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users