Gossamer Forum
Home : Products : Gossamer Links : Discussions :

UPDATE query

Quote Reply
UPDATE query
I'm looking for the mysql update syntax that will reset hits to zero for links with an ID below 1000

I tried:

UPDATE Links WHERE id < 1000 SET Hits= '0';

but it didn't work.

Any help would be much appreciated Tongue

Quote Reply
Re: [joey] UPDATE query In reply to
You almost got it..

UPDATE Links SET Hits = 0 WHERE ID < 1000

Last edited by:

Paul: Jul 26, 2002, 6:33 AM