Re: update question

[Christian Mack]

PinkeshP@stripped wrote:
> 
> I want to update a column called "viewed" every time that particular record
> was displayed in the query to keep track of how many times that record was
> displayed. What would be the efficient way to do this?
> 
> -----------------------------------------
> Pinkesh N. Patel

Hi Pinkesh

Just do:
SELECT ID, value1, value2, ... FROM table WHERE ...
UPDATE table SET viewed = viewed + 1 WHERE ID = valueYouGotInTheSelect

Tschau
Christian