# Search database **URL:** \ **Category:** WordPress Questions\ **Created:** [March 9, 2018, 4:20pm UTC](https://community.localwp.com/t/search-database/5585 "2018-03-09T16:20:55Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![vayu](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/vayu/32/4845_2.png) [@vayu](https://community.localwp.com/u/vayu)\ **Post date:** [March 9, 2018, 4:20pm UTC](https://community.localwp.com/t/search-database/5585/1 "2018-03-09T16:20:55Z")
Hi. How do I search the database for some specific value? I have tried to find a way in Sequel Pro and Adminer. I don’t know what table the value is stored in, so I need to search the entire database. Sequel Pro cannot do this kind of search and Adminer just will not find it. ---
**Author:** ![TonyG](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/tonyg/32/3095_2.png) [@TonyG](https://community.localwp.com/u/TonyG)\ **Post date:** [March 22, 2018, 8:28pm UTC](https://community.localwp.com/t/search-database/5585/2 "2018-03-22T20:28:39Z")
Hi @vayu, Are you searching for contents of a page, or something like a setting/customisation? Tony. ---
**Author:** ![vayu](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/vayu/32/4845_2.png) [@vayu](https://community.localwp.com/u/vayu)\ **Post date:** [March 22, 2018, 9:26pm UTC](https://community.localwp.com/t/search-database/5585/3 "2018-03-22T21:26:17Z")
Could be either, the point that I am trying to get at, is how to search all tables in Sequel Pro or Adminer? This is possible to do in phpMyAdmin. I just do’t understand why this cannot be done in those other two applications? Or can it? ---
**Author:** ![TonyG](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/tonyg/32/3095_2.png) [@TonyG](https://community.localwp.com/u/TonyG)\ **Post date:** [March 22, 2018, 9:33pm UTC](https://community.localwp.com/t/search-database/5585/4 "2018-03-22T21:33:50Z")
@vayu, Sequel Pro has a search bar at the top of the Content view of any table… ![sequelpro](https://us1.discourse-cdn.com/flex019/uploads/lwpforums/original/2X/5/5ba9446f3b39bbce19b12b8e38e7409c6866df36.png) Hope that helps. ---
**Author:** ![vayu](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/vayu/32/4845_2.png) [@vayu](https://community.localwp.com/u/vayu)\ **Post date:** [March 22, 2018, 9:47pm UTC](https://community.localwp.com/t/search-database/5585/5 "2018-03-22T21:47:03Z")
Thanks, I know. But that is not useful if there are 100 tables, and I don’t know which one to search. Even worse if I don’t know which table or field. I am looking for a global search, like in phpMyAdmin. ---
**Author:** ![clay](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/clay/32/8248_2.png) [@clay](https://community.localwp.com/u/clay)\ **Post date:** [March 23, 2018, 8:38pm UTC](https://community.localwp.com/t/search-database/5585/6 "2018-03-23T20:38:03Z")
@vayu, Have you tried MySQL Workbench’s search functionality? See [https://stackoverflow.com/a/26647118](https://stackoverflow.com/a/26647118) Here’s the link to download MySQL Workbench: [https://dev.mysql.com/downloads/workbench/](https://dev.mysql.com/downloads/workbench/) To connect to the database using MySQL Workbench, enter the details provided under the site’s MySQL tab in Local. ---
**Author:** ![vayu](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/vayu/32/4845_2.png) [@vayu](https://community.localwp.com/u/vayu)\ **Post date:** [March 23, 2018, 9:23pm UTC](https://community.localwp.com/t/search-database/5585/7 "2018-03-23T21:23:47Z")
No, I have not tried Workbench. I will give it a try. Thanks ---
**Author:** ![daniel](https://sea1.discourse-cdn.com/flex019/user_avatar/community.localwp.com/daniel/32/4605_2.png) [@daniel](https://community.localwp.com/u/daniel)\ **Post date:** [July 9, 2018, 6:10pm UTC](https://community.localwp.com/t/search-database/5585/8 "2018-07-09T18:10:16Z")
I haven’t used Workbench in awhile, but to chime in, I created a web site in Local named `phpmyadmin.local` where I have phpMyAdmin in a `/pma` directory with the various databases configured. It’s sort of a ghetto solution, but I like phpMyAdmin’s ability to search across multiple tables (I develop a huge multisite Locally with _many_ tables - impossible to find anything). It’s the only thing that I use PMA for, else I use Sequel Pro.