php search function
<p>I am attempting to create a search function for user profiles on my site.</p>

<pre><code>$search= $_POST['search'];
$res=mysql_query("SELECT * FROM ".TBL_USERS." WHERE username LIKE '$search%'");
</code></pre>

<p>This is the code I use. This will only work if you search something that matches the start of the result. Is there any way I can return values that have what i type as part of the username regardingless of upper or lower cases?</p>

<p>Thankyou</p>
