Jquery Autocomplete starts with first letter -

here code

<div>     <label for="dynamicsearch">search:</label>     <input id="dynamicsearch"> </div> 

---

$(function () {  // autocomplete     $("#dynamicsearch").autocomplete({         source: "dynamicsearch.php",         minlength: 1     }); }); 

dynamicsearch.php

<?php $con = pg_connect("connection"); if (!$con)   {   die("could not connect: " . pg_last_error());   }    $dynamicsearch = "select name bkash_dist name '%".$_get['term']."%' limit 10";    $result = pg_query($con, $dynamicsearch);        while($row = pg_fetch_array($result))       {                   $results[] = array('label' => $row['distrbutor']);             }    pg_close($con); $encoded = json_encode($results);   // send response index.html // , end script execution die($encoded) ?> 

when searching "a" giving result contains "a" want those start "a" or "a" (case sensitive). how can it?

simply change sql query looks beggining of result :

$dynamicsearch = "select name bkash_dist                    name                   '"$_get['term']."%'                   limit 10";