Menu
Looking for a nifty helper function/method for grepping through all defined tables, columns, stored procedures, etc, for a MySql database.
I had something similar for SQL Server.
934
Common Resource Grep (crgrep) searches for table/column name and data matches and supports MySQL. http://sourceforge.net/projects/crgrep/ Also searches other hard to search resources like content buried in archives.
Find data across a MySQL connection by using the text search feature on any number of tables and schemas. From the schema tree, select the tables, schemas, or both to search and then right-click the highlighted items and click Search Data Table from the context menu.
In the search grid, choose tables and views of interest or leave them all checked. To narrow down the MySQL search data scope, select the table, views, numeric, text type, and date columns checkboxes. To start the search, click the Find button or hit the Enter key from the keyboard.
mysqldump --compact --skip-extended-insert -u root -proot mydb | grep "interesting string"
110
In the INFORMATION_SCHEMA database:
select * from columns WHERE TABLE_NAME LIKE '%tablename%' AND COLUMN_NAME LIKE '%columnname%' More info here: http://dev.mysql.com/doc/refman/5.0/en/information-schema.html
Ok, it doesn't completely answer your question but you should be able to put it together how you want from here.
40
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
