OK, so you want to reset the values, not remove the fields themselves (you'd do that through the profile field manager in the admincp). Anyway, it would be something like:
Code:
UPDATE userfield SET field1='', field2='', ... fieldN=''
where you'd list the fields you want to erase, of course. Use with caution! If there's any doubt, you should make a backup of your database first.
04-19-2012, 05:54 PM
Threaded Mode