[SOLVED]Remove query \ delete from database

[danyxxx]

Hello,

Who know how I may run the sql remove query ?
I mean something like this: DELETE FROM table_name ....
I need to remove something from all rows once .
Do not reply me with the mothod that needs the row and column, it's not god for me .

Kind Regards .

[BirdOPrey5]

To remove something "from all rows at once" to me sounds like you want to delete (drop) an entire column.

If so that would be:

ALTER TABLE `table_name` DROP `colum_name`

But I'm not 100% sure that is what you are really asking.

[danyxxx]

I dont' want that I want to remove for exemple the text "http://forums" from all tables once .
The problem is that I can't use the column_name because the text is a virus or something and the browse function doesn't work :)

[BirdOPrey5]

There is no way to remove a value from all tables at once.

[danyxxx]

Ok, maybe form one once but without the column name , it's possible?

[TheLastSuperman]

Ok, maybe form one once but without the column name , it's possible?

I don't think so, you need something to identify by for example:

SELECT * FROM post WHERE pagetext LIKE "%http://forums%"

Into English:

Show all posts where the message contains http://forums

^ However you must be careful, if you then try to modify i.e. remove, replace the snippet is it affecting other posted URL's or Links? Basically you need to be very careful when executing SQL Queries and if you could tell us more, why your wanting to find http://forums and remove it, the reasoning per say we might be able to assist better ;).

[souperman]

Here's the delete code:


DELETE FROM post WHERE pagetext LIKE "%http://forums%"


Like the posters above have said, be very careful when deleting stuff from the db.