When you are performing a SQL UPDATE on multiple rows in MySQL, it seems that you can either put single quotes around every value or not and it will produce the same results.
Is there a reason for using single quotes in an UPDATE query if not using single quotes produces the same results? Is there any difference at all?
Example without quotes:
UPDATE superuser SET poop = rainbows WHERE id IN (1, 2, 3);
Example with quotes:
UPDATE superuser SET poop = rainbows WHERE id IN ('1', '2', '3');