Would it be easier to write a php script to create and index in an existing MySQL database? Or is it possible through the PHPMyAdmin program. I couldn't figure it out through PHPMyAdmin, but I could be missing something.

in phpMyAdmin, select the table that you want to put an index on. You'll then see all the fields for that table. At the end of each field row, there are little pictures such as edit and delete. The one with the lightingbolt will add an index. You can also hover over each of these pictures to see what they do.

Thanks Flann. :)


But now when I try I get this error

#1170 - BLOB column 'descriptor' used in key specification without a key length


How can i fix this so that I can use the index?

Thanks Flann. :)


But now when I try I get this error

#1170 - BLOB column 'descriptor' used in key specification without a key length


How can i fix this so that I can use the index?


I figured this part out. :)

Ok, I've got my FULLTEXT index created. Now How do i search the thing? I tried using a normal SQL search string (SELECT * FROM `dnd` WHERE keyword='acid') but it didn't work.

is there a record in your database where the keyword field equals acid? Always look at your data.