Navicat is a powerful database management and development tool that provides professional developers with a powerful set of sophisticated tools that are still easy to learn for new users. Let's introduce how to set up the Navicat Filter Wizard. The Filter wizard makes it easy to create and apply the specified filter criteria for the table grid, as well as save the filter to the settings file for later use, and click Filter on the toolbar to activate the editor. It is important to note that the Navicat Filter Wizard applies only to the full version of Navicat.
1. Add a new condition, click < add >.
2. Select the column, click the column box (next to the Check button) and select an item from the drop-down list.
3. Click the filter Operator box (next to the column box) and select an item from the drop-down list.
NAVICAT Filter Operators
4. Click the Criteria Value box (next to the filter operator box) to activate the appropriate editor and enter the criteria value, the editor used by the criteria value box is specified by the editor type to the appropriate column.
5. Repeat step 1-4 to add another new condition.
6. Click "Apply" or press Ctrl+r to view the filtered results.
Warm tip: You can save the filter criteria to load from the registry for later use, right-click on the Filter Wizard and select "Save settings File" or "Open settings file".
Articles about NAVICAT filtering records can also refer to the Navicat Tutorial: How to Filter Records .
The above is reproduced content, the original is: http://www.formysql.com/wenti/shaixuan-xiangdao.html
How to set the Navicat Filter Wizard