how to fast sql query

Question

hi friend can anybody tell me how to fast my sql query.I m insert some field from another table that has around 5 lak data,I just insert 100 row according to date.I have use clustred index on date but speed is quite slow due to where clause in which I have use a description field and their are lots of and i.e " (detail like '%car%' and '%truck%' ) OR (detail like '%shirt%' and '%pant%' ) " Is their any solution?