This is a short snippet of php code if you want to use a CodeIgniter database query inside a helper file/function: application/helpers/. Very easy to use.

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.