title: How to ignore non alphanumeric characters for SQL LIKE statement?
body: <p>I have an auto complete search box using ajax and its working as it should but its not efficient in finding things. I want to be able to search for something and not need to have commas or colons to actually return the correct result </p>
  
  <p>e.g. if i want Terminator 2 : Judgement Day and i search terminator 2 judgement day it doesnt return anything because i left out the colon :. I dont want this to happen. Since its an ajax auto complete its easy enough to still find it but i want to be able to find things without needing to have non alpha numeric characters</p>