title: Need Help with a basic sql query for my own search engine Implemention
body: <p>I am doing a search engine implementation in java (eclipse)
  i have a table named <code>tbl_index</code> where i save all the keyWords with a column named <code>keyWord</code> against which i save a URL in a column <code>url</code>.</p>
  
  <p>Now if a have a search term that consists of more than one words, how would i write a query to find all the URLs which have all the words.</p>
  
  <p><strong>table Info:</strong></p>
  
  <p>column1 : <code>keyWord (nvarchar(50))</code></p>
  
  <p>column2 : <code>url (varchar(800))</code></p>
  
  <p>these two are collectively the primary key of the table.
  Please suggest a way in which i dont have to change my talbe structure.
  Although it would be helpful to point out any mistakes in my current schema.</p>
  
  <p>Also please suggest some good indexing techniques to index the keywords i get from the html of the website(the column <code>keyWord</code>).</p>