How to exact search?

0 votes

How do you search for exact results? As an example I want to advanced search on region ='West', which would exclude 'Midwest'.

in How To by (280 points)

1 Answer

0 votes

The answer to that is not as clean as it should be. By default dbFront assumes that users want to do a like search so if you don't specifically include a '%' in the search string then it will surround your search text by '%' as follows: '%YourText%'.

You can adjust the search by specifically including a '%'. By including a '%' at the end you would prevent "West" matching to "Midwest".

by (1.1k points)
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
Powered by Question2Answer