search on comma delimited data doesnt find last item in data

[KrisNz]

Hi, I have a query like this..

SELECT `franchiseid` FROM `franchise` WHERE CONCAT(',', `postcodes`, ',') LIKE '%,7895,%' LIMIT 1

 

which searches data like 1021,1024,7895 etc

 

It mostly works, however, it doesn't match on the last item - in this case 7895. I can't see why it doesn't work when the concat puts the extra commas in I thought it would need to match. Can anyone suggest a fix or a better method?

 

Thanks.