title: MySQL - Case-insensitive search
body: <p>Building my search engine for users to search for three variables $Title, $Text and $Number...
  How do i make it when user searches it finds all results no matter the case type (lower or upper case) user typed in $query?</p>
  
  <pre><code>$query = trim ($query);
  
  $raw_results = mysql_query("SELECT * FROM posts
          WHERE (`Number` LIKE '%".$query."%') OR (`Title` LIKE '%".$query."%') OR (`Text` LIKE '%".$query."%') ") or die(mysql_error());
  </code></pre>