12.03.2015 Authorship by Mike 62 201

In Mysql the Random  function is called rand. If you want to develop an app that uses mysql and sqlite for development you will have a problem with the naming of the random funcktion:
Postgres, Sqlite: RANDOM()
Mysql: RAND()
 
You can add the alias RANDOM to mysql with this simple sql command:
CREATE FUNCTION random() RETURNS FLOAT NO SQL SQL SECURITY INVOKER RETURN rand();
 
Another Problem is case insensitive like in postgres the special ilike command is used.
E.g.
SELECT * FROM table WHERE name LIKE '%abc%';
would become
SELECT * FROM table WHERE UPPER(name) LIKE UPPER('%abc%');
 
This helped me to test my application with sqlite and have in development and production mode postgres/mysql.