UPDATE payment_transactions SET amount=CONVERT(REPLACE(REPLACE(amount_tmp," EUR",""),",","."),DECIMAL(9,2));
ALTER TABLE payment_transactions ADD KEY method_id (method_id);
ALTER TABLE payment_transactions ADD KEY ref (ref);
UPDATE payment_transactions SET amount=CONVERT(REPLACE(REPLACE(amount_tmp," EUR",""),",","."),DECIMAL(9,2));
ALTER TABLE payment_transactions ADD KEY method_id (method_id);
ALTER TABLE payment_transactions ADD KEY ref (ref);