<?php
$sql = <<<BLOCK SELECT server.server_id , server.server_name , server.ip , server.mac , server.sn , server_status.status , notes FROM server , server_status WHERE server.status_id = server_status.status_id AND %1\\$s LIKE '%%%2\\$s%%' ; BLOCK;

$s = sprintf($sql,'ip','10.');

?>