Multiple update

Question

I am trying to update two requests in my php script, but I cannot get it to work. The code:

UPDATE Table SET price = '14 .50 'WHERE type LIKE' finger ',' Knuckle 'AND ALSO quantity <= 50;

Ok, ive fixed the WHERE clause, but I don't understand what I need to change with the "14.50" part now getting the error?

0

Elise May 07 '09 at 12:34 am

3 answers

thomasrutter · Answer 1 · 2009-05-07T00:36:09+0000

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

bdonlan · Answer 2 · 2009-05-07T00:35:41+0000

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

Nathan Feger · Answer 3 · 2009-05-07T00:49:13+0000

you may also need

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

This will match any lines that contain a finger or joint.