Find Difference Between Two Numbers in Comma Separated Array : Suppose I have a MySQL table which has two rows and two columns.

Column 1 = ID
Column 2 = NUMBERS

NUMBERS field in first row & second row has following comma separated value:

NUMBERS(Row 1) = 1,2,3,4,5,6,7,8
NUMBERS(Row 2) = 6,7,8,9,10,11

Now I need to find all the numbers which are between 1 & 11. I have tried MYSQL BETWEEN function but it has not returned desired results. Is there a way I can get desired result?


