Full text indexing a column 1

[nborland]

I'm trying to set up a database in which I can quickly search for a word or words within a field and return the appropriate records. I know I can put an index on the column, but mysql only indexes from the beginning of the column, and I want to search in the middle of the text. Any suggestions as to how I can improve my search times over a full text match (which is very slow given my db size)?<br>
<br>
Phrased another way, I know how to index for<br>
&quot;something%&quot;<br>
but how do I index for <br>
&quot;%something%&quot;?<br>
<br>
Thanks!