<sql db="mysql:root:mysql1974@mysql_srv/probind"> select data,CONCAT(domain,'.druidesmetal.priv') as domain from records where data like '10.74.1.%' order by data; </sql>