This is a way to select words beginning with an uppercase. This query check if the first character is an uppercase by the function UPPER() and if the following character is a lowercase with the function LOWER().
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
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.
This is how you can create a function in MySQL to determine if a selected value is numeric or not.
<?php
CREATE FUNCTION IsNumeric (sIn varchar(1024)) RETURNS tinyint DETERMINISTIC
RETURN sIn REGEXP '^(-|\\+){0,1}([0-9]+\\.[0-9]*|[0-9]*\\.[0-9]+|[0-9]+)$';
UPDATE nodemap SET`nodemap_city` = CONCAT(SUBSTR(`nodemap_city`, 1, 3), ' ', SUBSTR(`nodemap_city`, 4, 2), SUBSTR(`nodemap_city`, 6)) WHERE IsNumeric(SUBSTR(`nodemap_city`, 1, 5)) = 1 LIMIT 1;
?>List your sites activated modules.
SELECT `name` , `status` , `weight` FROM `system` WHERE `type` = 'module' AND `status` =1 ORDER BY weight ASC LIMIT 0 , 200Compare your sites activated modules with an other sites modules list in the same database.