mysql like query with check of values in comma separated data

Vote count:

0

I have a table with data like this

'85530', 'Nargis Fakhri', '[2011,2013,2014]', '16'

'26683', 'Nawazuddin Siddiqui', '[1999,2006,2007,2009,2010,2012,2013,2014,2015]', '46'

'14508', 'Aditi Rao Hydari', '[2009,2011,2012,2013,2014]', '26'

Challenge is to find the rows for which the actors were only active in past 4 years and not in any other years, so essentially a good query should return only the first row of 'Nargis Fakhri' and not of any other actor, I know about Find_In_set but that's to find if actor existed for one particular year.

asked 2 mins ago

Brij Raj Singh

915

mysql like query with check of values in comma separated data