From: Dan Nelson
Date: June 19 2002 7:35pm
Subject: Re: multiple updates
List-Archive: http://lists.mysql.com/mysql/112515
Message-Id: <20020619193525.GA18597@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Jun 19), Won Lee said:
> Hi everyone,
> 
> I'm slowly starting to learn the nuances of MySQL.  I searched the
> HTML docs on mysql.com but the subject matter is so broad that I'm
> flooded with possible matches.  I read through some of the docs but I
> still don't have a solution.
> 
> 
>       UPDATE RFSMs
>       SET
>            approved = 1,
>       WHERE RFSMID IN (#variables.approvedID#)
> 
> While this should works in MSSQL Server, I haven't tested it out yet,
> I know it won't work in mySQL.

That should work, assuming "#variables.approvedID#" is with a single
integer, or a list of comma-dalimited ones.  What mysql does not
support is WHERE .. IN ( SELECT ... )  - i.e. subselects.

-- 
	Dan Nelson
	dnelson@stripped