Jump to content

Archived

This topic is now archived and is closed to further replies.

sbourdon

SQL query: a little help, please!

Recommended Posts

Hello,

I would like to create a php script that would execute a SQL query that would do the following:

Inside the topics_watch table, set the notify_status value to 0 for all users EXCEPT user_id 2.


What should the SQL query be?

Thanks for your help! [img src=\"style_emoticons/[#EMO_DIR#]/wink.gif\" style=\"vertical-align:middle\" emoid=\":wink:\" border=\"0\" alt=\"wink.gif\" /]

Share this post


Link to post
Share on other sites
UPDATE topics_watch SET notify_staus = 0 WHERE user_id NOT LIKE 2

Share this post


Link to post
Share on other sites
[!--quoteo(post=376352:date=May 23 2006, 09:30 AM:name=micah1701)--][div class=\'quotetop\']QUOTE(micah1701 @ May 23 2006, 09:30 AM) [snapback]376352[/snapback][/div][div class=\'quotemain\'][!--quotec--]
UPDATE topics_watch SET notify_staus = 0 WHERE user_id NOT LIKE 2
[/quote]

Perfect; thanks a lot!

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.