MSSQL TOP 1 mysql LIMIT 0,1

MSSQL:

SELECT TOP 1 Name, Released, label
FROM Album
WHERE  Released > #DateFormat(album.Released,'YYYY-MM-DD')# AND Released <= #DateFormat(now(),'YYYY-MM-DD')# AND (label like '%Flux%' OR label like '%Monochrome%' OR label like '%baskaru%')
ORDER BY Released ASC

mysql:

SELECT Name, Released, label
FROM Album
WHERE  Released > #DateFormat(album.Released,'YYYY-MM-DD')# AND Released <= #DateFormat(now(),'YYYY-MM-DD')# AND (label like '%Flux%' OR label like '%Monochrome%' OR label like '%baskaru%')
ORDER BY Released ASC LIMIT 0,1