I have a database items

Id name  order status   created
1  john  123    no       2020-07-06
2  deo   788    yes      2020-08-06
3  jane  987    no       2020-09-06
4  deo   234    yes      2020-11-06
[download]

my query to select

my $Check_status = $dbh->prepare("SELECT order FROM items ORDER BY cre
+ated ASC LIMIT 1");   
$Check_status->execute();
my $status = $Check_status->fetchrow();
[download]

so now am selecting 1 order which earliest created first but if that selected order status eq to no

then how can i run the query continuously and skip to next row if the previous one status eq to no

like

if ($status eq 'no') {
# skip to next row and check
}
[download]

so other part if status eq to yes i would like to commit changes and after success i continue to next row

if ($status eq 'yes') {
# commit changes 
# and then continue to check next row
}
[download]