Court or CT Lane or LN Boulevard or BLVD, etc
Is there a api that will sanitize a database into shorthand, or someway to clean a database so that when I do a search query I can find the address?
Currently I do:
WHERE prod.street_num = new.street_num AND prod.street_name LIKE (CONCAT('%',new.street_name,'%'))
I think changing your query to something like this can achieve what you want.
AND MATCH(prod.street_name) AGAINST (new.street_name IN NATURAL LANGUAGE MODE);
I have tried it online, which you can check out here, and it seems to be working with the functionality you want. You can also check the documentation on Full Text Search in MySQL here
(Note: I am mostly a Postgres user but I hope this helps!)