Add a column
Subscribe_Status
(bit datatype) in your table.
1 - Yes
0 - No
Based on the value, you need to do changes in your query. For example,
SELECT * FROM Tbl_Subscriptions WHERE Subscribe_Status=1
Above query picks only users(emails) who wants to subscribe.
Same way, you could change your query to remove users from resultset. Customize!