I was looking for the same and found that this query gives me the desired result. Although, I used Ruby on Rails to serialize the column product_ids, but if this can help for future readers

SELECT * FROM coupons WHERE product_ids LIKE '%---\\n- \\'71591\\'\\n%'