Forum Academy Marketplace Showcase Pricing Features

Tricky "Search Database" function

Hi all -

Bit of a tricky thing here…

My database is full of locations with addresses. In the address, the state is often listed with an abbreviation. For instance, CA (for California) or AZ (for Arizona).

Users can use a Search Bar to find the location they want. However, right now, if the user types in “Arizona,” the locations with “AZ” in the address do not appear.

How do I configure the database (or search bar) so that the user can type in the full name or the abbreviation and still get the same result. For instance, the user can type in “AZ” or “Arizona” and still get all locations in the state of Arizona.

Any ideas?

Thanks!