SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
BEGIN
SELECT x FROM y == 'test'

-- meantime other connection
   updates y set x='othertest'

SET SESSION TRANSACTION ISOLATION LEVEL
READ UNCOMMITTED
SELECT x FROM y = ???? (1)
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
SELECT x FROM y = ???? (2)