Subject searching a varchar(100) column
Author Sudheer Palaparambil

Can somebody tell me how to speed up search on a book title column
(varchar(100)), the user will be usually entering first 2 or 3 words of the
title. What I am using now is LIKE, but this is very slow on a table which
contains 120000+ records.

Any suggestion are greatly appreciated.

Thank you.