title: SQL Customized search with special characters
body: <p>I am creating a key-wording module where I want to search data using the comma separated words.And the search is categorized into comma <code>,</code> and minus <code>-</code>.
  I know a relational database engine is designed from the principle that a cell holds a single value and obeying to this rule can help for performance.But in this case table is already running and have millions of data and can't change the table structure.</p>
  
  <p>Take a look on the example what I exactly want to do is </p>
  
  <p>I have a main table name <code>tbl_main</code> in SQL</p>
  
  <pre><code>AS_ID   KWD
  1   Man,Businessman,Business,Office,confidence,arms crossed
  2   Man,Businessman,Business,Office,laptop,corridor,waiting
  3   man,business,mobile phone,mobile,phone
  4   Welcome,girl,Greeting,beautiful,bride,celebration,wedding,woman,happiness
  5   beautiful,bride,wedding,woman,girl,happiness,mobile phone,talking
  6   woman,girl,Digital Tablet,working,sitting,online
  7   woman,girl,Digital Tablet,working,smiling,happiness,hand on chin 
  </code></pre>
  
  <blockquote>
    <p>If  search text is =  Man,Businessman then result AS_ID is =1,2</p>
    
    <p>If  search text is =  Man,-Businessman then result AS_ID is =3</p>
    
    <p>If  search text is =  woman,girl,-Working then result AS_ID is =4,5</p>
    
    <p>If  search text is =  woman,girl then result AS_ID is =4,5,6,7</p>
  </blockquote>
  
  <p>What is the best why to do this, Help is much appreciated.Thanks in advance </p>