[categories] [index] [all (553)] [latest]

1. Add a fulltext index

   mysql> ALTER TABLE my_table ADD FULLTEXT(my_col);
   

   This doesn't work on InnoDB tables, but only on MyIsam ones.

   SELECT *
   FROM my_table
   WHERE MATCH (my_col)
   AGAINST('my_text');