title: Select with like LIKE Operator, in many-to-many database design
body: <p>I need help with a select, but before asking the question, I will give a short description of how my system works:</p>
  
  <p>tables I want to do the select, has a many-to-many relationship, look below:</p>
  
  <pre><code>table product:
  prd_cod(pk) //stores the product code ex: 0,1,2
  cat_cod(fk) 
  prd_name    //stores the product name, ex: tv, gps, notebook
  
  table description_characteristc:
  prd_cod(fk) 
  id_characteristic(fk)
  description //stores the description of the characteristic, ex: sony, 1kg, hj10
  
  table characteristic:
  id_characteristic (pk)
  name_characteristic //store the name of characteristic, ex: brand, weight, model
  </code></pre>
  
  <p>i have ready made in the index.php, a suggest jquery, that every word I type it's calls a php file that makes a select and returns the result, limit of 10, but this suggest I got a ready made in the internet, therefore it's select does not match with my business rule, however I would like to implement a new select to this suggest.</p>
  
  <p>the select with like '%', have to bring to the suggest box the prd_name and all description, of table description_characteristc. when the user click on the result will be sent per parameter to the other .php but this i dont need now,</p>
  
  <p>when the user type 'tv', the select will bring the result:</p>
  
  <pre><code>tv 
  tv led
  tv plasm
  tv samsumg
  </code></pre>
  
  <p>and when the user type 'tv s', the select will bring the result:</p>
  
  <pre><code>tv sony
  tv samsumg
  tv salom
  tv sxxxx etc
  </code></pre>
  
  <p>remembering that prd_name stores only 'tv'</p>