Tag > mysql
This is a short snippet of php code if you want to use a CodeIgniter database query inside a helper file/function which is based in the following folder ‘application/helpers/‘.
If you have a numerical value in a MySQL database table, that you want to UPDATE by adding a value to it, or subtracting a value from it. This can be done with a single 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.
SELECT * FROM 'table' WHERE 'column' REGEXP '[A-Z]'
Here are some tips that can really be helpful for MYSQL queries… quick reference.