The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
[SOLVED]Remove query \ delete from database
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 . |
#2
|
||||
|
||||
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. |
#3
|
|||
|
|||
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 |
#4
|
||||
|
||||
There is no way to remove a value from all tables at once.
|
#5
|
|||
|
|||
Ok, maybe form one once but without the column name , it's possible?
|
#6
|
||||
|
||||
Quote:
Code:
SELECT * FROM post WHERE pagetext LIKE "%http://forums%" 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 . |
Благодарность от: | ||
danyxxx |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|