Re: In query not working

[Byron Platt]

This feels a bit dodgy to me. I'm guessing the csv variable is actually being passed in and isn't a constant. I'm also guessing your foreignKeyId field is an integer which means you a comparing text with an integer which is not good practice. All that said the following should work:

DECLARE csv VARCHAR(255);
SET csv = '268,484,435';
SELECT *
FROM tableX
WHERE FIND_IN_SET(foreignKeyId, csv) != 0;