Portal Forums Member List Calendar Active Threads Staff UBBWiki
Previous Thread
Next Thread
Print Thread
Rate Thread
Re: Useful MySQL Queries for UBB.Threads
eslmix #258600 10/28/2004 11:12 AM
Joined: Feb 2004
Posts: 16
PDOstrander Offline
Newbie
PDOstrander
Newbie
Offline
Joined: Feb 2004
Posts: 16
Anyone get brave enough to try this out?

[] ?
UPDATE w3t_Users
SET U_Username = U_LoginName

Although I'm not sure if that will pull their U_LoginName, or will actually give everyone the literal display name of "U_LoginName" so I wouldn't really recommend trying it. [/]

I have a bunch of users who I need to make their eamil / fake email and user name / display name all match. A SQL call like this would save me a lot of time

P-
Sponsored Links
Entire Thread
Subject Posted By Posted
Useful MySQL Queries for UBB.Threads JoshPet 09/11/2003 9:25 AM
Re: Useful MySQL Queries for UBB.Threads AllenAyres 04/03/2007 7:56 PM
Re: Useful MySQL Queries for UBB.Threads Ian_W 05/05/2007 10:49 AM
Re: Useful MySQL Queries for UBB.Threads Beentheredonethat 09/27/2003 6:32 AM
Re: Useful MySQL Queries for UBB.Threads JoshPet 09/27/2003 9:25 AM
Re: Useful MySQL Queries for UBB.Threads AllenAyres 10/06/2003 7:58 AM
Re: Useful MySQL Queries for UBB.Threads JoshPet 10/06/2003 8:23 AM
Re: Useful MySQL Queries for UBB.Threads AllenAyres 10/06/2003 9:07 AM
Re: Useful MySQL Queries for UBB.Threads Sapphy 10/10/2003 4:04 PM
Re: Useful MySQL Queries for UBB.Threads Dave_L_dup1 10/10/2003 5:40 PM
Re: Useful MySQL Queries for UBB.Threads Sapphy 10/10/2003 9:45 PM
Re: Useful MySQL Queries for UBB.Threads Gardener 10/12/2003 12:11 PM
Re: Useful MySQL Queries for UBB.Threads Dave_L_dup1 10/12/2003 6:56 PM
Re: Useful MySQL Queries for UBB.Threads Gardener 10/15/2003 12:46 PM
Re: Useful MySQL Queries for UBB.Threads Beentheredonethat 11/16/2003 5:20 AM
Re: Useful MySQL Queries for UBB.Threads Gardener 11/16/2003 9:02 AM
Re: Useful MySQL Queries for UBB.Threads Beentheredonethat 11/21/2003 1:27 AM
Re: Useful MySQL Queries for UBB.Threads Gardener 11/23/2003 12:06 AM
Re: Useful MySQL Queries for UBB.Threads JoshPet 11/26/2003 2:54 AM
Re: Useful MySQL Queries for UBB.Threads Gardener 11/26/2003 3:25 AM
Re: Useful MySQL Queries for UBB.Threads Beentheredonethat 11/26/2003 5:34 PM
Re: Useful MySQL Queries for UBB.Threads Beentheredonethat 01/02/2004 11:25 AM
Re: Useful MySQL Queries for UBB.Threads omegatron 01/02/2004 7:46 PM
Re: Useful MySQL Queries for UBB.Threads Beentheredonethat 01/06/2004 2:38 AM
Re: Useful MySQL Queries for UBB.Threads Storm_dup1 01/06/2004 4:20 AM
Re: Useful MySQL Queries for UBB.Threads omegatron 01/06/2004 4:50 AM
Re: Useful MySQL Queries for UBB.Threads Pasqualist 01/08/2004 1:20 AM
Re: Useful MySQL Queries for UBB.Threads omegatron 01/08/2004 2:02 AM
Re: Useful MySQL Queries for UBB.Threads JoshPet 01/08/2004 2:38 AM
Re: Useful MySQL Queries for UBB.Threads Pasqualist 01/08/2004 10:20 AM
Re: Useful MySQL Queries for UBB.Threads scroungr 01/08/2004 4:29 PM
Re: Useful MySQL Queries for UBB.Threads omegatron 01/08/2004 4:34 PM
Re: Useful MySQL Queries for UBB.Threads scroungr 01/08/2004 4:35 PM
Re: Useful MySQL Queries for UBB.Threads omegatron 01/08/2004 5:02 PM
Re: Useful MySQL Queries for UBB.Threads scroungr 01/08/2004 5:10 PM
Re: Useful MySQL Queries for UBB.Threads CurlGirl 01/08/2004 9:03 PM
Re: Useful MySQL Queries for UBB.Threads scroungr 01/08/2004 9:27 PM
Re: Useful MySQL Queries for UBB.Threads omegatron 01/09/2004 12:14 AM
Re: Useful MySQL Queries for UBB.Threads scroungr 01/09/2004 12:38 AM
Re: Useful MySQL Queries for UBB.Threads omegatron 01/09/2004 1:11 AM
Re: Useful MySQL Queries for UBB.Threads CurlGirl 01/09/2004 6:14 PM
Re: Useful MySQL Queries for UBB.Threads omegatron 01/09/2004 6:20 PM
Re: Useful MySQL Queries for UBB.Threads CurlGirl 01/09/2004 6:30 PM
Re: Useful MySQL Queries for UBB.Threads Storm_dup1 01/14/2004 8:53 PM
Re: Useful MySQL Queries for UBB.Threads Storm_dup1 01/14/2004 9:01 PM
Re: Useful MySQL Queries for UBB.Threads dman_dup1 02/09/2004 12:54 AM
Re: Useful MySQL Queries for UBB.Threads scroungr 02/09/2004 3:31 AM
Re: Useful MySQL Queries for UBB.Threads dman_dup1 02/09/2004 4:18 AM
Re: Useful MySQL Queries for UBB.Threads smoknz28 02/16/2004 10:21 PM
Re: Useful MySQL Queries for UBB.Threads scroungr 02/17/2004 12:31 AM
Re: Useful MySQL Queries for UBB.Threads smoknz28 02/17/2004 3:58 AM
Re: Useful MySQL Queries for UBB.Threads scroungr 02/17/2004 4:55 AM
Re: Useful MySQL Queries for UBB.Threads AllenAyres 03/03/2004 6:47 PM
Re: Useful MySQL Queries for UBB.Threads JoshPet 03/03/2004 7:46 PM
Re: Useful MySQL Queries for UBB.Threads JoshPet 03/03/2004 7:55 PM
Re: Useful MySQL Queries for UBB.Threads AllenAyres 03/03/2004 8:47 PM
Re: Useful MySQL Queries for UBB.Threads JoshPet 03/04/2004 2:25 AM
Re: Useful MySQL Queries for UBB.Threads JoshPet 03/04/2004 2:26 AM
Re: Useful MySQL Queries for UBB.Threads AllenAyres 03/04/2004 4:09 AM
Re: Useful MySQL Queries for UBB.Threads JoshPet 03/04/2004 4:15 AM
Re: Useful MySQL Queries for UBB.Threads JoshPet 03/04/2004 6:20 AM
Re: Useful MySQL Queries for UBB.Threads AllenAyres 03/04/2004 7:09 AM
Re: Useful MySQL Queries for UBB.Threads AKD96 04/07/2004 11:42 PM
Re: Useful MySQL Queries for UBB.Threads omegatron 04/10/2004 5:21 AM
Re: Useful MySQL Queries for UBB.Threads AKD96 04/10/2004 9:35 PM
Re: Useful MySQL Queries for UBB.Threads AKD96 04/15/2004 8:52 PM
Re: Useful MySQL Queries for UBB.Threads scroungr 04/15/2004 11:46 PM
Re: Useful MySQL Queries for UBB.Threads AKD96 04/16/2004 2:15 AM
Re: Useful MySQL Queries for UBB.Threads JoshPet 04/16/2004 5:08 AM
Re: Useful MySQL Queries for UBB.Threads omegatron 04/17/2004 8:59 PM
Re: Useful MySQL Queries for UBB.Threads Ohmu 04/18/2004 4:08 AM
Re: Useful MySQL Queries for UBB.Threads scroungr 04/18/2004 5:20 AM
Re: Useful MySQL Queries for UBB.Threads Ohmu 04/19/2004 9:31 AM
Re: Useful MySQL Queries for UBB.Threads scroungr 04/19/2004 3:10 PM
Re: Useful MySQL Queries for UBB.Threads scroungr 04/19/2004 3:17 PM
Re: Useful MySQL Queries for UBB.Threads Ohmu 04/23/2004 2:48 AM
Re: Useful MySQL Queries for UBB.Threads msula 05/01/2004 8:35 PM
Re: Useful MySQL Queries for UBB.Threads Astaran 05/01/2004 9:26 PM
Re: Useful MySQL Queries for UBB.Threads scroungr 05/02/2004 5:05 AM
Re: Useful MySQL Queries for UBB.Threads Astaran 05/02/2004 5:06 PM
Re: Useful MySQL Queries for UBB.Threads msula 05/03/2004 9:57 PM
Re: Useful MySQL Queries for UBB.Threads Slawek_L 05/13/2004 9:48 PM
Re: Useful MySQL Queries for UBB.Threads oceanwest 05/27/2004 9:30 PM
Re: Useful MySQL Queries for UBB.Threads scroungr 05/27/2004 9:38 PM
Re: Useful MySQL Queries for UBB.Threads oceanwest 05/27/2004 11:00 PM
Re: Useful MySQL Queries for UBB.Threads Deejay_dup1 05/29/2004 1:20 AM
Re: Useful MySQL Queries for UBB.Threads AKD96 05/29/2004 2:57 AM
Re: Useful MySQL Queries for UBB.Threads IOGCadam 06/07/2004 8:43 PM
Re: Useful MySQL Queries for UBB.Threads scroungr 06/08/2004 2:06 AM
Re: Useful MySQL Queries for UBB.Threads DrChaos 07/06/2004 2:47 PM
Re: Useful MySQL Queries for UBB.Threads scroungr 07/06/2004 2:53 PM
Re: Useful MySQL Queries for UBB.Threads DrChaos 07/06/2004 10:59 PM
Re: Useful MySQL Queries for UBB.Threads scroungr 07/06/2004 11:58 PM
Review Forum Rules ChAoS_dup1 10/28/2004 8:42 AM
Re: Review Forum Rules JoshPet 10/28/2004 9:47 AM
Re: Review Forum Rules ChAoS_dup1 10/28/2004 12:25 PM
Re: Useful MySQL Queries for UBB.Threads PDOstrander 10/28/2004 6:12 PM
Re: Useful MySQL Queries for UBB.Threads Anno 10/28/2004 10:40 PM
Re: Useful MySQL Queries for UBB.Threads PDOstrander 10/29/2004 7:07 AM
Re: Useful MySQL Queries for UBB.Threads PDOstrander 10/29/2004 6:01 PM
Re: Useful MySQL Queries for UBB.Threads AKD96 11/16/2004 2:24 PM
Re: Useful MySQL Queries for UBB.Threads dparvin 11/21/2004 1:37 PM
Re: Useful MySQL Queries for UBB.Threads dimopoulos 11/22/2004 12:36 AM
Re: Useful MySQL Queries for UBB.Threads dparvin 11/22/2004 1:11 AM
Re: Useful MySQL Queries for UBB.Threads Astaran 12/02/2004 2:45 AM
Re: Useful MySQL Queries for UBB.Threads MattUK 01/25/2005 11:18 PM
Re: Review Forum Rules MattUK 01/30/2005 9:44 PM
Re: Review Forum Rules BWilliams_dup1 03/22/2005 7:47 AM
Re: Review Forum Rules scroungr 03/22/2005 8:36 PM
Re: Review Forum Rules jamesholst 04/15/2005 4:56 AM
Re: Review Forum Rules scroungr 04/15/2005 5:55 AM
Re: Review Forum Rules jamesholst 04/15/2005 5:09 PM
Re: More advanced query for deleting PM's ? Pasqualist 08/08/2005 2:52 PM
Re: More advanced query for deleting PM's ? Pasqualist 08/09/2005 12:09 AM
Re: More advanced query for deleting PM's ? AllenAyres 11/28/2006 8:14 AM
How to select U_Username twice? PaNTerSan 01/07/2007 6:46 PM
Re: How to select U_Username twice? PaNTerSan 01/07/2007 7:29 PM
Re: How to select U_Username twice? AllenAyres 01/08/2007 12:10 AM
Re: How to select U_Username twice? PaNTerSan 01/08/2007 12:31 PM
Re: How to select U_Username twice? AllenAyres 01/10/2007 7:15 AM

Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
• Stable Host
• bluehost
• InterServer
Visit us on Facebook
Member Spotlight
Nettomo
Nettomo
Germany, Bremen
Posts: 417
Joined: November 2001
Forum Statistics
Forums63
Topics37,575
Posts293,930
Members13,823
Most Online6,139
Sep 21st, 2024
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
Forum Rules · Mark All Read Contact Us · Forum Help · UBB.Dev
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2025 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.1
(Snapshot build 20240918)