MySQL UPDATE based on multiple WHERE variables

Is this possible?

[hannamyluv]

I need to make updates to a table in sql based on multiple variables, eg I need to tell the database that if a line in the table matches in columns "color", "size" and "shape", make the changes to that line.

Can I do this? If so, what is the proper way to format the command?

[syber]

Just connect the statements with AND

UPDATE mytable
SET mycolumn = 1
WHERE color = 'red' AND size = 'XL' AND shape = 'square'