You have a table with a column with many duplicates and you just want to keep one of each. Make a distinct copy of the table, remove the old table and rename the new one.
CREATE TABLE temp_table as SELECT * FROM duplicate_table WHERE 1 GROUP BY duplicate_column;
DROP TABLE duplicate_table;
RENAME TABLE temp_table TO duplicate_table;This example sumarize a value when aggregate to duplicates
In a feed from Hugin Online a customer added several line breaks, with a special comment, so it should look nice in the newsletter, but that didn't look nice on the site. So I had to remove certain line breakers but not all. So I explode the string into an array by the separator
<br> and restored them if the one before was the same, as is line break ASCII 13.
Remove all non-alphanumeric characters. Don't forget to use trim().
$replace = "/[^A-Za-z0-9\s\s+\.\:\-\/%+\(\)\*\&\$\#\!\@"\';\n\t\r]/";
$title = preg_replace($replace, "", $title);This is a MySQL script to use when you want to replcae a string in field.
SET @removeme = "background: silver";
SET @new = "background: #E7E7E7";
UPDATE my_table1 SET my_field1 = REPLACE(my_field1, @removeme, @new) WHERE 1;
UPDATE my_table2 SET my_field2 = REPLACE(my_field2, @removeme, @new) WHERE 1; Source: MySQL Reference manual #REPLACE(str,from_str,to_str)
If you want to replace a taxonomy term with another one and want it replaced at the node you can fill in this form and send it as an SQL query in phpMyAdmin.
But if you just want to move around in taxonomy, the Taxonomy Manager is absolutely fantastic if you just have your taxonomy stored as term, not in CCK. Taxonomy Manager won't have any effect in CCK.
Remove junk characters and only allow alphanumeric, letters and numeric (numbers)