See this link.
Might me help for you
http://answers.yahoo.com/question/index?qid=20070309043307AATLe9k
On 5 February 2010 17:46, misiaQ wrote:
> Instead of:
> -> else 2003
>
>-> where id between 1 and 6;
> Try
>-> else 2003
>-> end
> -> where id between 1 and 6;
>
> Or mayb
Instead of:
-> else 2003
-> where id between 1 and 6;
Try
-> else 2003
-> end
-> where id between 1 and 6;
Or maybe even:
mysql> update table1
-> set year=case when id IN (1, 2, 4) then 2000
-> when id IN(2, 4, 6) then 2001
-> else 2003
-> end
-> where id b
