MySQL / Oracle Cheat Sheet

I use Oracle a lot and MySQL a little so constantly have to look up how to do a few simple things in MySQL.

Description	MySQL	Oracle
Default value when null	IFNULL	NVL
To Date (using a sane date format)	STR_TO_DATE('2013-01-01',             '%Y-%m-%d')	TO_DATE('2013-01-01',         'YYYY-MM-DD')
If statement in select	IF(condition,    true_value,   false_value)	CASE WHEN condition THEN true_value ELSE false_value END
Add a day	DATE_ADD(sysdate(),           INTERVAL 1 DAY)	sysdate + 1
Check something	select 'this'	select 'this' from dual