Full-text search in databases
For more information about searching outside databases, refer to the search section in this documentation.
You can search for data in your database or in a group of databases without knowing the exact location of data.
In the Database tool window (View | Tool Windows | Database) , select objects in which you want to perform your search. You can select a database or a group of databases, a scheme or schemes, or even separate tables.
Right-click the selection and select Tools | Full-Text Search. Alternatively, press CtrlAltShift0F.
In the search field of the Full-text Search dialog, type your search request and click Search.
In the Find tool window, review search results. To open a database object, double-click it. To return to the Find tool window (View | Tool Windows | Find), press Alt03.
tip
To pin the tab with search results, right-click the tab and select Pin Tab.
note
For Apache Cassandra, IntelliJ IDEA creates several queries for one table because the database does not support the OR condition. You can preview all searching statements in the Preview (data_source_name) pane.
Option | Description |
---|---|
Match case | Searches only for those instances that are written the same way as the query (preserving the case). A search for |
Contains | Searches for a given combination of characters in words. For example, if you search for |
Starts with | Searches for a given combination of characters in the word beginning. For example, if you search for |
Ends with | Searches for a given combination of characters in the word beginning. For example, if you search for |
Matches | Searches for an exact combination of characters. For example, if you search for |
LIKE pattern | Searches for a combination of characters and SQL wildcards. For example, you can search for |
Text columns | Searches only in columns that support the LIKE operation. For example, CHAR, VARCHAR, TINYTEXT, TEXT, and DATE (Oracle). |
Only columns with full-text search indexes | Searches only in columns that have a created index. This feature is supported only for PostgreSQL, MySQL, and MariaDB. The query for PostgreSQL is |
Numeric columns | Searches only in columns with the numeric data type like INT, MEDIUMINT, SMALLINT, BIGINT, and others. |
All columns | Searches in all types of columns. For example, you can run this search to find a JSON element. |
Show first N matches per table/view | Limits the number of found results for a table or a view. |
Thanks for your feedback!