Find in results
Use Find in results to search the results of a query you've already executed.
Press Ctrl+F (⌘+F), or select the Find and Replace icon (
) in the
results toolbar, to open the find and replace bar. It docks in the top-right corner of the grid, so you don't lose your
place in the data.
Note
Search only checks rows that are already fetched. If a match hasn't loaded yet, scroll down to fetch more rows first.
For information on filtering the result set with a SQL expression, see Data filters.
Search¶
The bar is available in the grid, and in the text view of the result set, including when it's formatted as JSON or XML. Replace is available only in views that support editing.
Use these options to refine your search:
| Setting | Button | Description |
|---|---|---|
| Case sensitive |  |
Match the exact case of your search text (off by default) |
| Regular expressions |  |
Search with regular expressions. Press Ctrl+Space (⌃+Space) in the field to insert common patterns, such as tabs, line starts, or Unicode character codes |
| Whole word |  |
Match whole words only, not text inside longer words |
| Find in selection |  |
Search only the rows or cells you've selected instead of the whole result set |
When search reaches the end of the data, it wraps around to the beginning. Matches update as you type.
Select the up and down arrow icons, or press Enter and Shift+Enter, to jump between matches.
Info
If DBeaver can't find a match, the field's text turns red.
Tip
The bar remembers what you've searched for. Select the dropdown arrow next to the field, or press the up and down arrow keys, to reuse an earlier search.
Show matching only¶
Select the Show matching only icon, or press Ctrl+Enter (⌘+Enter), to turn your search into a live filter instead of just jumping between matches. When enabled, the grid shows only matching rows, and updates as you type.
Note
While Show matching only is enabled, DBeaver stops fetching more rows automatically. Turn it off, or close the bar, to fetch more rows again.
Tip
Open the context menu on the Show matching only icon to choose whether it filters as you type or only when you select it.
Closing the bar clears the filter and restores all rows.
Replace¶
Select the arrow icon on the left of the bar, or press Ctrl+R (⌃+R), to show the replace field. Enter the replacement
text, then select Replace (
) for the current match, or Replace All
(
) to replace all matches.
Note
Replace updates a cell the same way as editing it directly - the change follows your commit mode and still needs to be saved. For details, see Data viewing and editing.
Press Esc, or Ctrl+F (⌘+F) again, to close the bar.