WmZilla - Webmaster and Marketplace

The Next Generation Webmaster and Trade Forum

Multiple Update Command in the Database

EverFrost

New member

0

0%

Status

Offline

Posts

36

Likes

0

Rep

0

Bits

190

3

Months of Service

0%
We have a table in the XenForo database. You can see it here: [link]. I want to change the "email_confirm" values in this section to "valid." Is the following MySQL query correct for this task? I am hesitant to delete and reload the backup because the user is an Admin. Here is the query: UPDATE xf_user SET user_state = REPLACE ( user_state, 'email_confirm', 'valid' ). Is this query correct?
 

249

6,622

6,642

Top