MySQL Hint: REPLACE / UPDATE

Februar 7th, 2011

Replace strings with SQL in a field for all rows …

 
UPDATE `table` SET `field` = REPLACE(`field`, 'search string', 'replace with this') WHERE 1=1;

MySQL/SQL: count chars in table field

Dezember 28th, 2010

SELECT CHAR_LENGTH(field)-CHAR_LENGTH(REPLACE(field,’-',”)) AS count FROM table