Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jul 2006
Posts: 62
C
journeyman
journeyman
C Offline
Joined: Jul 2006
Posts: 62
Hi,

I want to change the value for 1 field in a table for all records in that table.

Specifically, in the Forum_permissions table, I think the default for the field ad_island is 0, I want to update every record so that the value for that field is 1.

Which in truth, it should be. Having that value set to one for every group is fine and won't change anything unless you actually designate a post island to be displayed in the forum details side.

Anyway, could someone help me out with the sql statement for that?

Joined: Jul 2006
Posts: 62
C
journeyman
journeyman
C Offline
Joined: Jul 2006
Posts: 62
Bleh, nevermind, got it. I'm a lazy bastard is all tongue

Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
SQL Query
UPDATE ubbt_USERS u, ubbt_USER_PROFILE up
SET u.USER_LAZY_BASTARD=1
WHERE u.USER_ID=up.USER_ID
AND up.USER_DISPLAY_NAME='Carte Blanche'

laugh

Joined: Jul 2006
Posts: 62
C
journeyman
journeyman
C Offline
Joined: Jul 2006
Posts: 62
/facepalm so true.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
2 members (Havenofsobriety, rootman), 624 guests, and 106 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)