From: Date: October 29 2005 12:09am Subject: Re: Possible to use a conditional in this UPDATE List-Archive: http://lists.mysql.com/mysql/191017 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit on 10/28/05 5:52 AM, Brent Baisley at brent@stripped wrote: > You can nest the IF statement, putting another where 'soon' is like > Jasper suggested. Or you can use the CASE WHEN THEN construct if you > have a lot of conditions you need to check for. Can you show me an example of the CASE method, I tried and it would error, the docs are a wee bit confusing in that regards. -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 Novato, CA U.S.A.