any 1 good with mysql?

[lenney]

i recently paid for a database from warezscene and had some 1 merge it in with mine now i have so many errors and so many members

is there some sort of mysql query i can run to remove member using x email address and then ill remove the posts etc manually

im talking like 50 thousand members i need removed

lenney Reviewed by lenney on 14th Mar 2009. any 1 good with mysql? i recently paid for a database from warezscene and had some 1 merge it in with mine now i have so many errors and so many members is there some sort of mysql query i can run to remove member using x email address and then ill remove the posts etc manually im talking like 50 thousand members i need removed Rating: 5

[Whoo]

DELETE FROM users WHERE mail IS LIKE 'x'

[lenney]

how can i do that please im stuck really bad and got the owners of the website doing my head in

[Whoo]

Give more specific information please. Like what mail and w/e....

[lenney]

well bassically what i need to do is run some sort of sql query which will delete the specific email addresses of the members as i do not think there is a way to remove the whole merged database

[Whoo]

Which email adresses are you looking for to remove? Do they have a comon thing like all users that have a mail @aol.com or what?

[lenney]

there is 50 thousand i have a whole list of them saved

[Whoo]

You could code a script to check if each mail in teh database equals a mail in the list

[lenney]

is there no way to just run a tool to remove them email addresses

[Whoo]

if you find a certain pattern that all those email you want to remove have in comon, like a registration date or from a certain id or such