Managing concurrent accessess to table(s)

[raymondaccounts]

Hi,

I have a java app that queries a table for rows which it needs to process. I want to be able to run multiple instances or the app for concurrent processing (I may do this also by having multiple threads query the app). Is there a way that the multiple instances of the app of multiple threads do not pick up the same row for a certain table so each instance or thread will be processing it's own set of rows?

Can this be done through MySQL or is this a client application issue?

Thanks in advance :)