By doing so a record must meet all criteria to be still shown: You can also combine multiple filters by just using two or more input fields.
SQLITE BROWSER FILTER FULL
Have a look at this example where we filter for those records with a value greater than one in Field3:įor a full list of supported operators see the table below. You can do so by adding one of the supported operators at the beginning of your query. You can override the default ‘containing’ search by specifying a comparison operator. You can change the case sensitivity in the Pragmas tab (release 3.11 or later). Here’s an example:īy default, we perform a ‘containing’ filter for numbers and a ‘containing’ (non case sensitive) filter for text. You are free to use as many ‘%’ wild cards as you wish and in any combination. ‘b%’ filters for records starting with ‘b’, ‘%b’ filters for records ending in ‘b’ and ‘%b%’ filters for records containing a ‘b’ at any position (this is the default filter option). In this case all you need to do is type ‘b’ in the column’s filter: Say, you want to filter for those records where Field2 contains ‘b’.
This section provides some examples for people not familiar with SQL. The filter is performed as soon as you start typing (you can configure the delay time in Preferences). These filters allow you to perform quick filters in the currently selected table. When browsing a table a filter row consisting of one input field per column is shown between the table header and the actual table data.
0 kommentar(er)
