Solved

MYSQL Find

Posted on 2014-12-15
4
108 Views
Last Modified: 2014-12-29
Hi i have a value B1-1 somewhere in my database and I dont know what the table or column is.

What is the best way of searching for something so that I can locate where it is in the DB
0
Comment
Question by:ncomper
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 7

Expert Comment

by:Ray
ID: 40501392
Try SQLYog (14 days free trial), it has the Data Search function to search values in tables/fields
0
 
LVL 58

Accepted Solution

by:
Gary earned 500 total points
ID: 40501413
PhpMyAdmin or Adminer will allow you to do a search thru the whole db.
0
 
LVL 51

Expert Comment

by:Huseyin KAHRAMAN
ID: 40501469
dump it to a text file and do a text editor like notepadd++ to locate it :)

mysqldump -u myuser --no-create-info databasename > myfile.sql
0
 
LVL 51

Expert Comment

by:Huseyin KAHRAMAN
ID: 40501475
Maybe this works for you

MySQL Workbench
http://dev.mysql.com/downloads/workbench/5.2.html
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
PHP & MySQL - Rounding Results from a Select Query 3 42
MySQL Query Using Up Memory 6 53
how to access a remote mysql database with xampp 3 42
Very Large data in MYSQL 7 94
Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question