Hello I use dancer 1 with with mysql @resultCC = database('db')->quick_select('ClientContrat', { NumContrat => { like => "$search%" } }, { limit => 10 } ); I send @resultCC to my template tt and it's work well I would like to pass complex query my $sql ="SELECT Client.CodeClient, Client.NomClient,Client.Ville, ClientContrat.NumContrat FROM Client INNER JOIN ClientContrat ON (Client.CodeClient = ClientContrat.CodeClient) WHERE Client.CodeClient LIKE '%" .$search. "%' LIMIT 10"; I do not find solution to use current mysql connection , and quick_select ? ( it 's ok only if I create new connection with , connect, prepare execute ....) what is the best way to do that ? thanks Hugues.