<div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im">&gt; Also mysql is case sensitive (I think)<br>
<br>
</div>I thought &#39;like&#39; wasn&#39;t case sensitive and<br>
<a href="http://dev.mysql.com/doc/refman/5.0/en/pattern-matching.html" target="_blank">http://dev.mysql.com/doc/refman/5.0/en/pattern-matching.html</a> seems to<br>
support this, saying &#39;In MySQL, SQL patterns are case-insensitive by<br>
default.&#39; and giving the example:<br><br></blockquote><div> </div><div>The lower case search term &#39;%formula 1%&#39;  has always picked up the titles for me which invariably begin with an upper case &#39;F&#39;.</div>
</div>