The Arcive of vBulletin Modifications Site.

mangmel · #1 06-08-2014, 09:22 AM

how to UPDATE user profile field1 back to blank text all user ?

We have custom profile field with Single-Line Text Box.

Lynne · #2 06-08-2014, 02:49 PM

Ummm, possibly like this (you probably want to change field1 to something else though since you probably didn't really mean field1, right?)

Code:

UPDATE userfield
SET field1='';

As always, backup your database prior to running ANY commands and always test the query on your test site/database first.

mangmel · #3 06-09-2014, 06:15 AM

nice moved! solved

....
THANKS