MySQL Delete using IN Clause not deleting all rows

Hi @Haseeb1399 Thanks for reaching out. Looking at our docs, IN should work for arrays in MySQL queries

If you hardcode an array of ids like the below example, does it work?

DELETE FROM yelp_accountria_similarity WHERE yelp_accountria_similarity.created_at IN ({{[1699, 2101]}})

If not, is that created_at column a unique column with matching records for 1699, 2101, etc?

Do you have the prepared statements setting disabled on your MySQL resource settings? Disabling this setting is not recommended as it can have security risks and can also lead to syntax issues