Remember, full-text search can only be implemented on fields of type varchar or text. The "fulltext()" keyword declares an instance of a fulltext index. You can create as many indexes in this manner as you wish (it can be helpful if you want to implement several search criterias, like by name or by job). Here, we will have only one criteria. Now populate this table with more than 10 records, so that we can do some useful testing. "The more, the better", actually.
etc. Now test the table...
Step 2: USE For using the feature, you just have to use this query....
This query will return all the results which are related to "Prakash". The feature is NOT case-sensitive and has the ability to automatically remove "useless" words such as the, a, an, for, and etc.......
Prof. Ashay Dharwadker