A "good" way to perform your query would be to design the table with address parts instead of address lines.
primary_number: 3127
street_predirection: E
street_name: Warm Springs
street_suffix: Rd
secondary_number: 200
secondary_designator: Ste
city_name: Las Vegas
state_abbreviation: NV
zipcode: 89120
plus4_code: 3134
delivery_point: 50
delivery_point_check_digit: 4
first_line: 3127 E Warm Springs Rd Ste 200
last_line: Las Vegas NV 89120-3134