I changed the alias setting from canonical to redirect in the admin settings and now I can't get to my site because I get a redirect loop.

 Hostname Example: mysite.temporary.whatever.com/myfolder  

There is no trailing slash but the site is in a subdirectory so I have to have a slash after the domain.

How can I change the alias setting back to canonical if I can't get to the site at all now? SQL command maybe?