sql queries

Naylin’s replacing user_login with user_nicename

UPDATE father23_users SET user_login = user_nicename WHERE ID IN (SELECT user_id FROM father23_usermeta GROUP BY user_id)

 

Update

UPDATE `tbl_overview` SET `category_id`='6' WHERE `category_id`='5'
Advertisements