How to use a cursor in mySQL for selective rows?

I want to loop on my table and based on some condition i want to return a specific rows. How can I create a s开发者_JAVA百科imple cursor for that? Do I need to create a temporary table for this?