MySQL user-def. variable -- Can I do something like this?

[mrherman]

This attempt throws an error, but how close am I to getting something like this to work?  (using 5.1) 

 

Thanks.

 

SET @myvar = 
        '(
          "1021X", 
          "2020X", 
          "2023X",
          "2024X"
         )'
         
UPDATE mytable
SET myfield = "Y"
   WHERE myvalue IN @myvar ;

 

[fenway]

You have some quoting issues.