Query compatibility?

[boivie]

I have this query in my script:

$db->query('SELECT * FROM users WHERE id IN (1,2,45,67)');

How compatible is the WHERE .. IN ...-part? It works in MySQL, but will it work with PostgreSQL or Oracle? If I had access to these then I would find it out myself, but I'm counting on you 🙂

thanks in advance.

[Anon]

No problem with that query.

Mysql is the least capable dbms.

[boivie]

Great, thanks.