if faq had a sequenced primary key you could do the following
select a.sezione, IF(a.sezione = b.sezione, "no","yes") as hasChanged
from faq as a, faq as b
where faq.id = faq.id -1
-Original Message-
From: Luca Accomazzi [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 11:02 AM
To
.
- Original Message -
From: "Luca Accomazzi" <[EMAIL PROTECTED]>
To: "Rolf Hopkins" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, June 04, 2001 20:47
Subject: Re: Help! MySQL variables laugh at me
> > I have only had a quick look o
> I have only had a quick look over this and already have a question for the
> simple example you've provided. How are you determining the last value
> entered before entering the new value? The only way I see you of
> effectively accomplishing this is through the use of a datetime column. Or
>
I have only had a quick look over this and already have a question for the
simple example you've provided. How are you determining the last value
entered before entering the new value? The only way I see you of
effectively accomplishing this is through the use of a datetime column. Or
am I miss