MySQL/SQL: count chars in table field Dezember 28th, 2010 SELECT CHAR_LENGTH(field)-CHAR_LENGTH(REPLACE(field,’-',”)) AS count FROM table