• 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