Hey guys. For various embarrassing reasons, I'm using:
SELECT x FROM userTable WHERE name LIKE 'name' To look up entries in my account table. Basically, the scripting language I'm using which hooks into SQLite is a bit case-agnostic. I've been told by a friend that this is extremely inefficient, and that I should UPPER my 'name' column and my query name in order to get it to be fast. Can anyone tell me the easiest way of doing this? Thanks, Ian _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
