title: Auto complete suggestion box are not working properly?
body: <p>code:</p>
  
  <pre><code>&lt;?php
    include('config.php');
    $return_arr = array();
    $term = $_GET['term'];
    $term = str_replace('.','',$term);
    $sql = "SELECT * FROM submission where keyword like '%".$term."%' or companyname like '%".$term."%' ORDER BY CASE WHEN keyword LIKE '%".$term."%' THEN 1
    ELSE 2 END";
    $r = mysqli_query($link,$sql);
    while($row = mysqli_fetch_assoc($r))
    {
      $key = explode(",", $row['keyword']);
      foreach ($key as $keyword) 
      {
        $return_arr[] = $keyword;
      }  
    }
    echo json_encode($return_arr);
  ?&gt;
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/nJEpa.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nJEpa.png" alt="enter image description here"></a></p>
  
  <p>In my code I have created a auto complete suggestion box and its working but it always showing wrong result if I write (i) it always show result with (a) alphabet why not (i) and also want to search with short name. So, How can I do this ?Please help me.</p>
  
  <p>Thank You</p>