If you have problem after enabled SSL, here is the quick fix. Go to admin/controller/sale/order.php in line 850 change $data[‘store_url’] = $this->request->server[‘HTTPS’] ?
Fastest way to replace a table field string with SQL statement. UPDATE [THETABLENAME] SET [THEFIELDNAME] = REPLACE(THEFIELDNAME, 'string_to_replace', 'new_string')