Need help with an SQL Query

[SnapOff Racing]

I am trying to delete all the signatures of every member that is in the banned user group. I have created a select statement that does what I want but now I just need some help creating an UPDATE or DELETE statement.

select signature
  from usertextfield
  join user
    on user.userid = usertextfield.userid
 where user.usergroupid = 8

Thanks in Advance! :up:

[SnapOff Racing]

bump^^

[kh99]

I haven't tried this, but I think it would be:

update usertextfield
  join user
    on user.userid = usertextfield.userid
  set signature=''
 where user.usergroupid = 8

ETA: I did a quick test on a junk db and it seems to work.

[SnapOff Racing]

Twice in two days! Damn I need to put you on the payroll!

Thanks for your help AGAIN I really appreciate it! :up:

[borbole]

I have coded a mod that does that if you don''t want to do it manually.

https://vborg.vbsupport.ru/showthread.php?t=249634