if we have a table innodb unsigned int:
the query "UPDATE table SET total=total-1 ... " cause error if total <=0

how to make a conditional update in one query?

TIA