• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 133
  • Last Modified:

MYSQL Find

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
ncomper
Asked:
ncomper
  • 2
1 Solution
 
RayCommented:
Try SQLYog (14 days free trial), it has the Data Search function to search values in tables/fields
0
 
GaryCommented:
PhpMyAdmin or Adminer will allow you to do a search thru the whole db.
0
 
HainKurtSr. System AnalystCommented:
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
 
HainKurtSr. System AnalystCommented:
Maybe this works for you

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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now