After looking at the response I tried to make 2 mySQL queries that I need
help with. (I didn't use the PHP functions because I am trying to query
the database for results:
#1:
SELECT `word` FROM `bible_concordance_words` WHERE SOUNDEX('command')
ORDER BY `word` ASC
- There are no results, I don't understand because Commanded, Commander,
Commanding, Commandment, Commandments are all in the datase
#2:
SELECT `word` FROM `bible_concordance_words` WHERE command SOUNDS_LIKE
`word` ORDER BY `word` ASC
- I receive the error:
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'SOUNDS_LIKE
`word` ORDER BY `word` ASC
I think it wants me to specify an actual word, not the `word` column.
Is there a way to tweak either of the syntaxes I have started?
Ron
> Hello, Ron:
>
> I apologize if I was supposed to reply to the list directly, however.. I
> saw no direct way to do so that would also ensure my reply to you.
>
> I believe the functions you are looking for would be :
>
>- levenshtein()
> -
>Calculate Levenshtein distance between two strings
>- metaphone() -
>Calculate the metaphone key of a string
>- similar_text()
> -
>Calculate the similarity between two strings
>- soundex() -
>Calculate the soundex key of a string
>
> You would need to use your word and then run the words you want displayed
> as
> possible matches through this function. Alternatively, SQL also has the
> Soundex function , and MySQL has sound_like, which means you could get the
> possible matches returned through the dataset.
>
> Hope this helps!
>
>
>> -- Forwarded message --
>> From: "Ron Piggott"
>> To: php-db@lists.php.net
>> Date: Mon, 11 Oct 2010 17:12:17 -0400
>> Subject: "Similar to" searches
>>
>> 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
>>
>>
>>
>
>
> --
> "Act only according to that maxim whereby you can at the same time will
> that
> it should become a universal law." - Kant
> "He who learns but does not think, is lost; He who thinks but does not
> learn
> is in great danger." - Confucius
>
The Verse of the Day
Encouragement from God's Word
www.TheVerseOfTheDay.info
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
