Search for a value in all tables in DataGrip

Question

I can't find a search function with which I can search all tables in a database for a certain value in DataGrip.

This functionality does exist in other database tools, see:

• PhpMyAdmin
• MySQl Workbench
• HeidiSQL

I don't know how to achieve similiar functionality with DataGrip

Answer 1

Version 2019.2 of DataGrip supports full text searches.

1. select datasources, schemas or even separate tables in Database view
2. select Full-text Search in context menu
3. enter query and hit enter

See https://youtrack.jetbrains.com/issue/DBE-87#focus=streamItem-27-3621219.0-0