if i have a table like this
id | name | values
1 abc 1,2,3,4,5,6
2 abc1 1,2,3,4,5,6,7,8,9
3 abc2 1,2,3,4,5,6,7,10,12,13,45
4 abc 1,2,3,4,5,6,15,16,45
5 abc3 1,2,3,4,5,6,7,8
i have to select those record according to @variable value='7' in the values field columns of all records and how to split the values with commas
for example select * from table name where '7' lies in values