> 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
