SQL to MySQL query translation

[Andy.]

I can muddle my way through SQL queries, but now I have to use MySQL.

Can anybody tell me what I should be using for the IN clause in the below SQL query to make it work in MySQL?

Select *
FROM xxx
WHERE MACHINE.NAME IN 'xxx0001','xxx0002','xxx0100')

Cheers!

 

[Tim.]

Where's the opening bracket?

 

[Andy.]

LOL! It was only a rough draft. The key part is how to run the equivalent of IN in MySQL...

 

[Andy.]

Never mind. Found it. Time for the weekend to start.