A numerical value in a MySQL database table, needs to be updated by adding or subtracting a value. This can be done with a simple MySQL query.

I recently had a problem searching for values containing any uppercase characters in a MYSQL database. I had this little query but with no luck.

Here are some tips that can really be helpful for MYSQL queries for quick reference. Including Database control functions and the like.