I'm having an issue with a website I wrote in PHP on a WAMP server on Windows, issue is, it's now being deployed on a Linux server. The site is quite big and I've done all my queries this way in all caps:
"SELECT COLUMN FROM TABLE"
And most of the tables/columns in the database use a different case (For example, Column).
I cannot use lower_case_table_name=1
since there are other PHP websites on the server that would be affected negatively. Is there a way for me to switch all of my database's tables and columns into upper case?