How to retrieve values by searching into comma separated values.Hi,
I need to retrieve a value by searching a similar string in the database column which is having comma separated values.
My table has the values as:
index category keywords contentid
1 c# encapsulation 2
2 c# regular, expression 7
Now i need to get contentid by matching the keyword similarity. I used the following code, It retrieves the content id if its a single keyword as encapsulation. but if i give regular it shows no rows affected and no output.
SELECT content_id FROM tbl_index WHERE keywords LIKE @keyword;
I need the content id 7 if i give regular or expression as input.