The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
![]()
help me please, I want to mass update only thoose users whoose "game" field is not empty.
How can i do it?? :ermm: |
#2
|
|||
|
|||
![]()
[sql]UPDATE vb_user set thefield='fieldcontent' WHERE game='';[/sql]
this will update the field "thefield" when the field "game" is empty ... |
#3
|
|||
|
|||
![]()
Thank you very much nexialys
|
#4
|
|||
|
|||
![]()
ohh its wrong mate, its updated me all the users whoose "game" field is empty, i asked only thoose whoose game table is not empty. :surprised:
|
#5
|
||||
|
||||
![]() Code:
UPDATE user SET field = 'content' WHERE game != '' |
#6
|
|||
|
|||
![]()
thank you Velocd
|
![]() |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|