Search and Remove - phpMyAdmin

['K']

Hi,

On my hosting I have setup a forum and basically for a certain member who has been banned I would like to remove all trace of him so basically in phpMyAdmin is there a querie I can run in a table to remove a/all rows containing

"whatever" under the "author_name" column so that the entire row/rows which contain "whatever" under the "author_name" column will be removed.

Thanks

btw the Forum is InvisionBoard if anyone needs to know.

Cheers

[SJH]

DELETE FROM table_name WHERE author_name = 'whatever';

is the syntax. Sorry I'm not familiar with the workings of Invision Board so I can't give you the exact specifications

-Sam

['K']

Hi,

Thanks for that

I'll go try it.

[SJH]

Hold on a sec... in the admin panel of IB, if you delete a user, if I remember correctly, all of that user's posts will be purged as well. No need to use phpMyAdmin here.

-Sam

['K']

Unfortunatly with iB it doesnt purge the posts.

The phpMyAdmin route worked though Thanks!

Would there be any way to make a page where you enter into a textbox the table name, and into another the author_name so I could use this in the future, and I guess the SQL Connection info would have to go in the page someplace but I have no clue when it comes to this

If you could help that would be great

['K']

or if anyone else can help with the above, page creation, then i'd appreciate it

Thanks a lot guys.