$query = "SELECT * FROM cofa WHERE apellido like '$apellido%' ORDER BY apellido ASC";
$query = "SELECT ... '%$apellido%' ORDER BY ...";