mysql optimizing table question

[alex79]

I have a table with next structure:

CREATE TABLE `table` (
`keywords` TEXT NOT NULL
) TYPE = MYISAM ;

where the rows are like:
row1: keyword1,keyword2,keyword5,...
row2: keyword10,keyword435,keyword5123,keywordn...


i want to make selects like this:

select * from `table` where `keywords` like '%keyword2%'

how do i optimize the `table` for a such selects? if i create an index on `keywords` column don't help becouse index are created after the firsts characters from column and are useful for selects with where `keywords` like 'keyword2%' not for selects with where `keywords` like '%keyword2%'

How can optimize the table for a such select?

[darksoul]

http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html

[darksoul]

also another option (fastest) would be
table keywords (entry_id int auto_increment, keywords text, primary key(entry_id))
table keywords_index (keyword varchar(16), simulated_array varchar(256))
where simulated_array would reference table keywords
its more work but its the fastest for search