Skin id change query help, thanks.

[NarutoFTW]

Can someone write me the query to look up all users who are have set their account to use a specific skin (we would look it up using the skin id, eg:81). then I need a query to change all users who have set skin id 81 to use a different skin (id).

[kh99]

I think what you want is:
SELECT username, userid, styleid FROM user WHERE styleid=81


and to change them to style X:

UPDATE user SET styleid=X WHERE styleid=81