I have a table bills having columns
id, starting_bl_no, ending_bl_no.
How can I verify that a new invoice number is already entered in the table?
id starting_bl_no ending_bl_no 1 100 140 2 357 500 3 150 190
Note: ie, if the entry is 102 I should go back exists. Or if the entry is 145 should return does not exist