- preg_replace: documentation ( source)
<?php
$query = 'SELECT * FROM akmailmkt_10001.TMEMMSG WHERE 1=1 AND emmsg_tipo_mensagem != "S" AND emmsg_cliente = 10001 ORDER BY emmsg_data DESC';
echo preg_replace('SELECT (.*) FROM', 'SELECT COUNT(*) FROM', $query);