Hi friends,
I had a database table as follows ...
Id | Film Name | Director | Cast |
----------------------------------------
12 | Dhoom | Name | 123,128,125,458,12
12 | Dhoom 2 | Name | 129,158,147,455
------------------------------------------------
I need search by cast column
For eg :
If I select :- select from table where cast like "%12%"
Then it will select 2 rows even if "12" is in only one row ....
Please help me how we can avoid this
Thanks in advance
Thankyou for your valuable time
Rajeesh