UPDATE cdr, routes SET cdr.costo=((cdr.durata/60)*routes.cost)/10000 WHERE cdr.chiamato RLIKE routes.pattern ORDER BY LENGTH(routes.pattern) DESC, routes.cost #1221 - Incorrect usage of UPDATE and ORDER BY