Hi,
I think your problem is that OR and AND do not
have the same precedence, AND binds tighter.
So what you need is probably:
(products_model=5217-01 OR products_model=5217-01) AND
products_um=CS and the same for PK and EA.
The way you have you'll get an update as soon as
products_model=5217-01
cybermalandro cybermalandro [EMAIL PROTECTED] wrote on
03/20/2006 11:00:51 AM:
I am trying to update a table with a file that has more than one update
statements like this:
UPDATE products set products_price=22.00 WHERE
products_model=5217-01
OR products_model=521701 AND
Hey guys! thanks a bunch that really fixed my problem. Thanks for your
prompt response.
cybm
On 3/20/06, Johan Höök [EMAIL PROTECTED] wrote:
Hi,
I think your problem is that OR and AND do not
have the same precedence, AND binds tighter.
So what you need is probably: