I am trying to get fields that have partial matching addresses to match via different suffixes for addresses.. for example:
10 hideman Street would qualify as a match of 10 hidman St.
These are the suffixes I am working with so far:
This is my query, but I need to know how to edit it to match the address fields with the above conditions:
`group`.`Additional Address Line 1`,
`group`.`Additional Address Line 1` = smart.Address