[BizzyD]

Hello, I was just wondering if there is a quick and easy way to remove all non rp names from the mysql database?
For example, delete everyone who hasnt a "_" in their name

[iZN]

This should work.

Код:

DELETE FROM table_name IGNORE _

EDIT: Might not, I will edit it when I'll get the solution.

[Smally]

If you are doing it with phpMyAdmin then execute this query:

SELECT * FROM tblName WHERE tblName.NameField NOT LIKE '%_%';

[BizzyD]

Yea I am doing it from phpmyadmin smally Will try that, thanks

[Smally]

Take a backup first, dude.

[BizzyD]

I wont try it on the main database ofc :P

[Misiur]

Quote:

DELETE FROM users WHERE id IN ( SELECT * FROM ( SELECT id FROM users WHERE name NOT LIKE '%\_%' GROUP BY id ) AS u )

Single query which matches all nonrp names (double subselect is due to mysql restrictions when deleting stuff)

[BizzyD]

I tried both of yours. They both returned 0

[Smally]

Did you change the query to match your table name and username etc?

[BizzyD]

yea I did