sql help for the syntactically challenged

You are not logged in. [Log In] UBB.threads Community » Forums » Managing & Customizing your Board » Admin Zone » sql help for the syntactically challenged

Site Links

Top Posters (30 Days)

Latest Photos

Topic Options

Rate This Topic

#215120 - 07/03/08 04:11 PM sql help for the syntactically challenged
Carte Blanche journeyman Registered: 07/30/06 Posts: 77 Loc: New Zealand	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?
Top

#215121 - 07/03/08 04:19 PM Re: sql help for the syntactically challenged [Re: Carte Blanche]
Carte Blanche journeyman Registered: 07/30/06 Posts: 77 Loc: New Zealand	Bleh, nevermind, got it. I'm a lazy bastard is all
Top

#215142 - 07/04/08 08:28 AM Re: sql help for the syntactically challenged [Re: Carte Blanche]
Sirdude Registered: 04/19/07 Posts: 2066 Loc: SoCal, USA	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' _________________________
Top

#215242 - 07/06/08 06:56 PM Re: sql help for the syntactically challenged [Re: Sirdude]
Carte Blanche journeyman Registered: 07/30/06 Posts: 77 Loc: New Zealand	/facepalm so true.
Top

Hop to:

Moderator: Gizmo

Shout Box

Today's Birthdays