UPDATE [ db.table | table ]
          WHERE WhereClause
          SET ( column1 = value, column2 = value... ) |
                    ([column1, column2...]) VALUES (column1_value, column2_value...)
          [ LIMIT LimitClause ]

This statement will allow for a user to update [a] row[s] of information in the table/database combination provided that fit a certain criteria (the WHERE clause).

If a $limit is defined, then txtSQL will stop updating rows and return the number of rows updated at the $limit. NOTE- This limit only needs one value (i.e. array(20) stops at 21 rows) unlike a regular limit clause.

If a column is of type enum and the value being updated does not exist as one of the enum values, the last value from the enum list is inserted.

NOTE- To have a complete look at the UPDATE function, and any changes to its functionality, see the update() function