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:

SELECT `word` FROM `bible_concordance_words` WHERE SOUNDEX('command')
- There are no results, I don't understand because Commanded, Commander,
Commanding, Commandment, Commandments are all in the datase

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?


> 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:
>> 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
> --
> "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

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to