Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

UPDATE query

Jul 26, 2002, 6:21 AM
joey
Novice (20 posts)
Jul 26, 2002, 6:21 AM
Views: 1211
Shortcut
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

Joey
Subject Author Views Date
Thread UPDATE query joey 1211 Jul 26, 2002, 6:21 AM
Post Re: [joey] UPDATE query 		Paul 1167 Jul 26, 2002, 6:32 AM