i created fulltext index on table in mysql database, , left out column when did so. have been trying figure out how add column can searched against along other columns in table have been indexed.
i have searched , web, not getting anywhere. tried going phpmyadmin, , when click on table , @ structure, way on right there dropdown says "more." has "fulltext" option seems add fulltext indexing column, did this, still not allowing me search column.
did add fulltext column? either way, how work?
alter table foo drop fulltext old_ft_index_name, add fulltext(this, that); 