alter table fulltext 1

alter table fulltext

ALTER TABLE table_name  
ADD FULLTEXT(column_name1, column_name2,…)

Here is what the above code is Doing:
1. We’re adding a FULLTEXT index to the title and body columns of the posts table.
2. We’re adding a FULLTEXT index to the title and body columns of the comments table.

Similar Posts