I'm trying to compare a list of URLs in a database to a list of files in a directory on my server. When I execute an SQL query that uses "ORDER BY", capitalization is a factor in the order that the items are printed. "ls" in Unix doesn't take capitalization into factor, so things get screwy when I try to compare the two. Is there a way to disregard the capitalization?
Thanks.
Post some more details of example URLs from your server and what you have in your db table. Also, it helps if you specify which operating system and RDBMS you are using. Post your existing SQL statement as well.
could you use strtolower?
I initially didn't want to change the capitalization, just the order, because it would cause problems when trying to compare the two lists, but I suppose that if I remove the capitalization on both, it won't be a problem.
Thanks. Resolved. 🙂
