Accounts phpmyadmin clean?

[TKO]

hello!
Is it possible to clean accounts that dosent have any chars on them?
if what sql commad?

 

[krille09]

search, i know there is

 

[Evil Puncker]

DELETE FROM `accounts` WHERE NOT EXISTS (SELECT `id` FROM `players` WHERE `accounts.id` = `players.account_id`);

try that, i dont mind if u rep me

 

[TKO]

krille09 i did search coulnt find any usefull then
Evil i will tet it

 

[TKO]

#1054 - Unknown column 'accounts.id' in 'where clause'

 

[cbrm]

DELETE * FROM `accounts` WHERE NOT EXISTS (SELECT `id` FROM `players` WHERE `accounts.id` = `players.account_id`);

 

[Cykotitan]

you don't need * between DELETE and FROM

 

[cbrm]

i know, but it has worked fine for me before

 

[Doggynub]

Wont differ ..