Getting first row where x = y

[slj90]

Hello,

 

I have a table with 3 columns, ID, Name and Status. The data under the status column will either be 'complete' or 'in_progress'. 

 

How do I find out the ID of the first row which says 'in_progress'?

 

Do I have to search each row or is there a way to go straight to that row?

Thanks,

[Ch0cu3r]

You'd use a select query with a where clause checking for Status is set to "in_progress" and then limit the results to 1 with LIMIT 1

SELECT ID, Name, Status FROM table WHERE Status='in_progress' ORDER BY ID ASC LIMIT 1