On 21/07/2010 16:33, Karthik Pr wrote:
> I have created a table as follows but i was not able to use full text search on
> a specific data.
> create table racebike (id int auto_increment not null primary key, name
> varchar(10), user text,fulltext(name,user));
> The query is
> mysql> select * from racebike where match (user) against ('speed');
It should be:
mysql> select * from racebike where match (name,user) against ('speed');
When using a fulltext index, the query has to name all the fields
included in the index, unless you're performing the search in Boolean mode.
|• Help me||Karthik Pr||21 Jul|
| • Re: Help me||Mark Goodge||21 Jul|