All pastes #260475 Raw Edit

Miscellany

public text v1 · immutable
#260475 ·published 2006-11-28 12:22 UTC
rendered paste body
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