Best performance for WHERE LIKE AND ..

[Sen7inel]

I'm doing heavy searches on a table with statements like

SELECT * FROM thetable WHERE col1 LIKE '%ab%' AND col1 LIKE '%cd%'

.. and so on. I need to search for keywords shorter than 4 characters, so I can't use fulltext MATCH-AGAINST. When searching using WHERE-LIKE -method above, should I use FULLTEXT or INDEX in the column in question?

 

[KarveR]

probably both, however indexing should have enough effect.

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.