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 `,` and minus `-`.
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.

Take a look on the example what I exactly want to do is 

I have a main table name `tbl_main` in SQL

```
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 

```

> 
> If search text is = Man,Businessman then result AS\_ID is =1,2
> 
> 
> If search text is = Man,-Businessman then result AS\_ID is =3
> 
> 
> If search text is = woman,girl,-Working then result AS\_ID is =4,5
> 
> 
> If search text is = woman,girl then result AS\_ID is =4,5,6,7
> 
> 
> 

What is the best why to do this, Help is much appreciated.Thanks in advance