my ($img_id) = $str =~ m/img_id=(\d+)/; my $prev_id = $img_id - 1; my $next_id = $img_id + 1; #### "select WHATEVER from TABLE where img_id in ($prev_id, $img_id, $next_id)"