title: MySQL SELECT first letter of the words sequentially for searching
body: <p><strong>Sample words:</strong></p>
  
  <pre><code>iknkr st nm krt prk
  iknkr vhgr j k pth  
  iknkr hkm st
  iknkr sr vhgr j k pth
  </code></pre>
  
  <p><strong>Required Condition</strong></p>
  
  <p>Now, if a user types: <code>ik s</code> the query will return:</p>
  
  <pre><code>iknkr st nm krt prk 
  iknkr sr vhgr j k pth
  </code></pre>
  
  <hr>
  
  <p>if a user types: <code>i v</code> the query will return:</p>
  
  <pre><code>iknkr vhgr j k pth
  </code></pre>
  
  <p><strong>Currently Trying:</strong>  </p>
  
  <pre><code>SELECT `walpha` AS word, pageID AS id 
  FROM `SX01` 
  WHERE `table`= 'S01' 
    AND `walpha` like '" . $this-&gt;db-&gt;escape_like_str($searchVal['keyword']) . "%' 
  LIMIT 100"
  </code></pre>
  
  <p>But using this user have to type: <code>iknkr s</code>  </p>
  
  <p>to get the result  </p>
  
  <pre><code>iknkr st nm krt prk 
  iknkr sr vhgr j k pth
  </code></pre>
  
  <p>Can anyone suggest, what will be the right way of doing it.</p>