[cardine]

I am working on a PHP script, and I want it so it searches a database for something (such as "MySQL is very fun to use"). Now I want it so that if there was no result called "MySQL is very fun to use", then it searches for the most similar entry (such as "MySQL is fun to use" or MySQL is easy to use".) Is that at all possible, and if it is, may somebody explain it to me, or point me to a place that does?

Thanks!

Also I understand basic MySQL (how to do searches, and other simple stuff like that).

Also if this isn't possible, is there any way to reverse wild card (wild card the results instead of the search). This would mean that if you searched for "MySQL is fun and easy to use", then "MySQL is fun" could show up.

[mab]

Take a look at full text searches - http://dev.mysql.com/doc/refman/5.0/...xt-search.html

[Keith]

Sounds like you want to utilize full-text searching. Here's a nice tutorial:
http://www.zend.com/zend/tut/tutorial-ferrara1.php

[NeverMind]

Moved to the appropriate forum.

as for your question, full text search is the answer, some tuts:
http://www.devarticles.com/c/a/MySQL...-Capabilities/
http://www.phpfreaks.com/tutorials/129/0.php
http://www.zend.com/zend/tut/tutorial-ferrara1.php

edit: wow! 3 posts in 2 minutes all with the same answer