I am a bit of a newbie to MySQL so there may be an easy answer, but if I have a multi-threaded application that is accessing a MySQL database is there a way to lock a row in a table so that only one thread can alter an entry? For instance a way to do a query and then cycle thru the recordset by first locking the row (so I know no other thread is altering it) and then doing what I need to do and then unlocking it?
