title: selecting the same data in different row from database
body: <p><a href="https://i.stack.imgur.com/Yi2gz.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Yi2gz.jpg" alt="enter image description here"></a></p>
  
  <p>i need to select the 'name' attributes must same value with 'seek' attribute.
  is kind like a match making concept which i need to select the 'name' attribute = 'seek' attribute in same table
  so the outcome will be     </p>
  
  <pre><code>name      | seek
  HEADPHONE | KETTLE
  KETTLE    | HEADPHONE
  </code></pre>
  
  <p>anyone can give me the solution on how to do it. i currently doing my final year project. Thank you </p>