Did anyone hear about "match against" construction? I is easy to build this: $query = "SELECT *, MATCH field AGAINST ('$searchwords') as relev FROM table ORDER BY relev DESC" (you need do "ALTER TABLE table ADD FULLTEXT(field)" before. This could be usefull: http://detail.phpclub.net/download/search_with_relevance.txt Regards, A.K. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php