title: Unable to check for row state(locked or not) in MySQL
body: <p>In my application I need to make a lock on some rows when those are edited. If another user will make a select on that rows, his query will need to wait until first user release the lock. My problem is that i need to see if query is waiting, so in that case to be able for making an appointment for user that makes the query. Do you have any suggetion for this scenario?
  Thanks in advance.</p>