2

Possible Duplicate:
MySQL - Search in all fields from every table from a database

I am looking for some MySQL GUI tool, that searches for a string in all databases/ tables/ fields. I have tried Toad, MySQL Workbench and HeidiSQL, It seems none has this feature.

Thanks in advance...

Community
  • 1
  • 1
jsist
  • 5,223
  • 3
  • 28
  • 43

2 Answers2

0

phpMyAdmin. I have tried search among all tables in a Database. it use to Search globally in a database or a subset of it.

manurajhada
  • 5,284
  • 3
  • 24
  • 43
  • But it seems for phpMyAdmin, I need to have some Apache server or something like that to be installed to get phpMyAdmin to get to work. MySQL is installed on my local machine. – jsist Jul 24 '12 at 05:35
  • right.. you can install it separately or using `xampp` that will install all the needs itself. – manurajhada Jul 24 '12 at 05:37
0

Try Find Object feature in dbForge Studio for MySQL.

Start dbForge Studio, run Find Object window (menu Database\Find Object...), enter Find What string, check Search table data, select all databases in Database combobox, and click Search button.

Devart
  • 119,203
  • 23
  • 166
  • 186