mysql 字段存在特殊字符,MySQL计数字段中特殊字符的出现

I am wanting to count all occurrences of the @ symbol in a field and originally i thought LIKE '%@%' would be the way to go, but if the character appears in the field more than once it only counts it as one.

What other method are there that i could use that would count every occurrence?

Thanks.

EDIT

For anyone needing it, this is what i ended up using that works.

$count = 0;

$sql = mysql_query("SELECT LENGTH(field_name) - LENGTH(REPLACE(field_name,'@','')) AS 'occurs' FROM table_name WHERE field_name LIKE '%@%'");

while ($data = mysql_fetch_assoc($sql)) {

$count += $data['occurs'];

}

echo $count;

解决方案select length('aa:bb:cc:dd')-length(replace('aa:bb:cc:dd',':',''));