How can i improve Auto complete %LIKE%
<p>From data base i have student record like this:
<a href="https://i.stack.imgur.com/13plH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/13plH.png" alt="enter image description here"></a></p>

<p>Hallticket name <strong>S22J79</strong> (S-student J-job).</p>

<p>This  Hall-ticket created based on <code>studentid</code> and <code>jobid</code>.</p>

<p>Now i have a Autocomplete functionality to retrieve the particular student based on <code>student_fname</code> and <code>student_lname</code> and <code>student_pid</code></p>

<p>My question is how can i retrieve the student data based on total hallticket number</p>

<p>this is my code:</p>

<pre><code>$studentsQuery =$conn-&gt;query('
select s.student_fname as label,i.email,s.student_pid,s.student_email,s.student_fname,
s.student_lname,s.profile_pic 
from 
   r_job_invitations i 
 LEFT JOIN 
   tbl_students s 
 ON 
   i.email = s.student_email 
 where 
    i.id_job = "'.$job_id.'" and 
    student_fname LIKE "'.$keysearch.'%" OR
    student_lname LIKE "'.$keysearch.'%" OR 
    student_pid LIKE "'.$keysearch.'%" ');
</code></pre>

<blockquote>
  <p>i am able to get student details if i type "22" then Mohammad waheed
  is coming <strong>but</strong> when i type total hall-ticket number i.e <code>S22J79</code> it
  is not coming even the key word consist "22" in it how can i tell
  system to read that "22" from hall ticket number..?</p>
</blockquote>

<p>so is there any advance level of <strong>%LIKE%</strong>..?</p>