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
NuvoForum LeaderVPS - 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!!!
Comments
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...
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!!!
The Royal Ram