"Similar to" searches
| From: | Ron Piggott | Date: | Mon, 11 Oct 2010 21:12:17 +0000 |
| Subject: | "Similar to" searches | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-47384@lists.php.net to get a copy of this message | ||
I am wondering if there is a way to or how you would have mySQL query for
similar words in comparison to what the user provided.
I have a table which contains only single words. It has two columns:
-
reference int(10) NOT NULL AUTO_INCREMENT,
- word varchar(100)
I am wondering if there is a way to cross reference the word the user has
provided to similar words in the database (So I could offer "SEE ALSO:"
links).
An example: If the word the user has provided is: Forced
I would like the mySQL query results to find the words: Forcing, Force and
Forces to be the results of the query in the words database.
Is there any way of achieving this?
Ron
The Verse of the Day
Encouragement from God's Word
www.TheVerseOfTheDay.info