title: Is there any alternative of 'like' operators in sql - for searching data
body: <p>I need some help here, I am fetching data dependent upon the conditions</p>
  
  <p>Here I am using like operators, where client may use search with any word thus I have the below logic but here retrieval time is too high (it's taking 4mins) to get the data which is too slow.</p>
  
  <p>I did all indexing to table but still can't optimize the query.</p>
  
  <p>select * from authors 
  where (address like '% Walmart %' OR address like 'Walmart %' OR address like '% Walmart' OR address like '% Walmart.com %' OR address like 'Walmart.com %' OR address like '% Walmart.com' OR address like '% Walmarts %' OR address like 'Walmarts %' OR address like '% Walmarts' OR address like '% Walmarts.com %' OR address like 'Walmarts.com %' OR address like '% Walmarts.com') </p>
  
  <p>-- Result is 1 Rows </p>
  
  <p>if i follow this logic</p>
  
  <p>select * from authors 
      where address like '%Walmart%'</p>
  
  <p>-- Result is 44 rows - it is fetching all rows</p>
  
  <p>But I need to get only that one row</p>