sql command

[mangmel]

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

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

[Lynne]

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

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]

nice moved! solved


....
THANKS