Re: Searching shopping cart
| From: | Chris | Date: | Mon, 02 Jun 2008 00:20:37 +0000 |
| Subject: | Re: Searching shopping cart | ||
| References: | 1 2 3 4 5 6 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-45022@lists.php.net to get a copy of this message | ||
> 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/