Search a database but all cases

PythonPython Forum LeaderThe Royal RAM
Ive got a basic search script which searches a column in a table...

The problem is that it is case sensitive. How do I make it non case-sensitive so that if you searched for something like "HelLo" then also "hello" would display as a result...

Thanks

The Royal Ram

Comments

  • NuvoNuvo Forum Leader VPS - Virtual Prince of the Server
    mySQL isn't case sensitive, so it should get the same results no matter what case they are in.
    The web directory script I'm working on brings up results for "web" without bothering about if I searched for "WEB", "wEb" or "Web" and I haven't used any extra code to get it to do so...
    Because of the result highlighting I added, my system does change the casing of the search term in the results when displayed though...
    PHP, CSS, XHTML, Delphi, Ruby on Rails & more.
    Current project: CMS Object.
    Most recent change: Theme support is up and running... So long as I use my theme resource loaders instead of that in the Rails plug-in.
    Release date: NEVER!!!
  • PythonPython Forum Leader The Royal RAM
    ahh yes so it is.. sorry...

    The Royal Ram

Sign In or Register to comment.