Multiple Update

Question

I'm trying to update two query's in my php script but i can't get it to work. The code is:

UPDATE table SET price = '14.50' WHERE type LIKE 'finger', 'Knuckle' AND quantity <=50;

Okay, ive fixed the WHERE clause but i don't understand what i need to change with the '14.50' part which is now picking up an error?

LIKE is equivalent to "=" unless you put a wildcard somewhere. — dkretz
– dkretz, Commented May 7, 2009 at 0:40
It generally acts the same as =, except that = ignores trailing whitespace for VARCHAR and CHAR types, and = performs transformations according to character collation (so "ae" is equal to "ä"), whereas LIKE doesn't. dev.mysql.com/doc/refman/5.0/en/… For the purpose given in this questions, however, it is safe to treat them equivalently. — thomasrutter
– thomasrutter, Commented May 7, 2009 at 1:39

thomasrutter · Accepted Answer · 2009-05-07 00:36:09Z

4

UPDATE table SET price = '14.50' WHERE type IN('finger', 'Knuckle') AND quantity <=50;

answered May 7, 2009 at 0:36

118k31 gold badges153 silver badges170 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

bdonlan · Accepted Answer · 2009-05-07 00:35:41Z

UPDATE table SET price = '14.50' WHERE (type LIKE 'finger' OR type LIKE 'Knuckle') AND quantity <=50;

Nathan Feger · Accepted Answer · 2009-05-07 00:49:13Z

you may also want

update table set price = '14.50' where (type like '%finger%' or type like '%knuckle%') and quantity <= 50

This will match any strings in which finger or knuckle are contained.