> Would someone show me a sample query from the table? I have tried to > get this to work during the past half hour and I don't understand this > type of query yet. > > Where I am at with my search query that doesn't work is: > > SELECT MATCH ( 'product_description_search') AGAINST ( 'Jesus') FROM > shopping_cart_product You don't use the index name in the match, you use the columns you want to search. select match(col1, col2) against('keyword') from tablename; As mentioned in the mysql manual: http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php