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 table is as follows,
+----+---------+---------------------+
| id | name | user |
+----+---------+---------------------+
| 1 | pulsar | style and speed |
| 2 | Harley | stylish and costly |
| 3 | aprilla | good sports bike |
| 4 | honda | costly and speed |
| 5 | suzuki | nominal and speed |
| 6 | Bullet | stylish and classic |
| 7 | Karizma | style and high cc |
| 8 | Fz | bigger and speed |
+----+---------+---------------------+
The query is
mysql> select * from racebike where match (user) against ('speed');
Thanks in advance
Karthik.P.R
