title: how to find a specific word from table using Like in sql server
body: <p>how to search word in SQL server.</p>
  
  <p>I am working on search bar module.</p>
  
  <p>When I search women in a search bar it will show all women listing and that is correct. But when I search men It shows all listing of men and women.</p>
  
  <p>I have used this below query:</p>
  
  <pre><code>select * from product where title like '%shirt%for%men%'
  </code></pre>
  
  <p>I want to search for word not for characters.</p>
  
  <p>How can write a query to search only particular word from the tables?</p>