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.
>From: "Kraer, Joseph" <jkraer@stripped>
>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
>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
Be the first to hear what's new at MSN - sign up to our free newsletters!