[SOLVED] UPDATEing multiple rows WHERE one column = multiple values.....

[boo_lolly]

i'm having trouble UPDATEing a column in my table where another column matches a few values.

pseudo query explaining what i'm looking for:

$sql = "
        UPDATE
                my_table
        SET
                my_column = '1'
        WHERE
                id = ('2', '5', '1', '16') //for each of these rows
";

 

make sense? can someone help me figure this out? i've approached this query many different ways, but to no avail, none of them worked.

[boo_lolly]

i figured it out:

$sql = "
        UPDATE
                my_table
        SET
                column = 'value'
        WHERE
                my_id_column
        IN
                ('4', '41', '2', '6')
";

 

 

that worked