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)?
Phrased another way, I know how to index for
but how do I index for
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.