title: programming for keyword search from database?
body: <p>Hello I have a table with following columns.</p>
  
  <pre><code>Profile_ID,
  Name,
  Age,
  More_Info_about family,
  qualification details, 
  job details and 
  partner_preference
  </code></pre>
  
  <p>I have to search on keyword basis and keyword is to be taken from textbox.</p>
  
  <p>The search result should be in such a way so that if keyword presents in starting, ending and in between the sentence of any of the columns presents in where conditions.</p>
  
  <p>I tried LIKE '" + txtbox_keyword.Text + "'
  but is not working properly it is not searching data if keyowrd is present in between sentense.</p>
  
  <pre class="lang-sql prettyprint-override"><code>select (Profile_ID,Name,Age, More_info_about_family,Job_Business_Location_City,Salary 
  from tblRegistration  
  WHERE More_info_about_family LIKE '" + txtbox_keyword.Text + "' 
     OR LIKE '" + txtbox_keyword.Text + "' 
     OR origin LIKE '" + txtbox_keyword.Text + "' 
     OR Job_Detail LIKE '" + txtbox_keyword.Text + "' ", con);
  </code></pre>