3 ms·
That' a common way to implement (faceted) search where the search expressions are dynamic depending on the user input. With this style, if the user wants to sea
by ako 3y ago
That' a common way to implement (faceted) search where the search expressions are dynamic depending on the user input. With this style, if the user wants to search on one or more fields you simply add "and field = :value" and you don't have to check if it's the first or next search expression.
The 1=1 doesn't hurt, as it will be removed by the query optimizer anyways.