Add datetime in MySQL

Example: plus datetime 31 days;

• update table_name set datetime_field = ADDDATE(datetime_field, 31);

Example: minus datetime 31 days;

• update table_name set datetime_field = ADDDATE(datetime_field, -31);

How to use MySQL RegExp

You can use RegExp in MySQL like this.

- SELECT column_name FROM table_name WHERE column_name COLLATE utf8_bin REGEXP '^.* [a-zI]$'

Note: COLLATE is use for use case sensitive in SQL.