Hi,
In your query you try to update on the condition "column 1 = number2 and
column1 = number3".
I think what you want is " column 1 = number2 or column1 = number3" .
If you use and it will try and found a record in column which has a value =
number2 and at the same time = number3.
hth,
melanie
From: "Kraer, Joseph" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Subject: Newbie Question on Update
Date: Wed, 30 Nov 2005 11:58:56 -0500
I am trying to update a couple of rows in a table by doing the
following:
update table
set column5 = number1
where column 1 = number2
and column1 = number3
but it is not working. I tried listing the conditions separated by
commas (where column 1 = number2, column1 = number3) and also didn't
work. What am I doing wrong?
Thanks in advance,
Joseph "Tito" Kraer
Business Systems Analyst
Taylor, Bean & Whitaker Mortgage Corp
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
_________________________________________________________________
Be the first to hear what's new at MSN - sign up to our free newsletters!
http://www.msn.co.uk/newsletters
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]