Like operator in sql server

Question

I want to get all the record from the one table which contain atleast one word from the input string. Ex: input parameter='Stack over flow':

select * 
  from sample 
 where name like '%stack%' 
    or name like '%over%'
    or name like '%flow%'

I want to search record which contains 'stack' or ' over' or 'flow' ...

Answer 1

The code you gave should work. But don't use it. It won't be able to use any indexes, and so will likely be very slow. Look into a full text index and the CONTAINS keyword instead.