Nolock on MySQL

SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ;

SELECT * FROM YOURTABLE

SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ ;