Improve company productivity with a Business Account.Sign Up

x
?
Solved

Using Phpmyadmin to search for a field in a table

Posted on 2014-04-24
8
Medium Priority
?
464 Views
Last Modified: 2014-04-24
Hello

i am somewhat familiar with phpmyadmin

Using Phpmyadmin phpMyAdmin - 2.11.11.3 MySQL charset: UTF-8 Unicode (utf8)

I have a large number of tables and I want to search the mysql database for an id.  Specifically ID 125.  The ID is unique for a specific bit of content I am looking for.  It's an id for an "article" in a Joomla site.  

Different tables have different structures, however I *think* the item I am looking for is as follows:

Table: blah_content  Field: id  Search term 125

If that doesn't get me what I am searching for there is another search I'd like help for

Table: blah_content   Field: asset_id    Search term: 125

If you can provide me the search syntax for those two hopefully I can find what I am looking for.

Thanks

Rowby
0
Comment
Question by:Rowby Goren
  • 3
  • 2
  • 2
7 Comments
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 40019829
Rowby: Are you open to the idea of a custom script to look for this information in all the tables?
0
 
LVL 35

Accepted Solution

by:
Dan Craciun earned 2000 total points
ID: 40019833
SELECT * FROM blah_content WHERE 
id = 125 OR asset_id = 125

Open in new window


HTH,
Dan
0
 
LVL 9

Author Closing Comment

by:Rowby Goren
ID: 40019842
Thanks Dan for that instant response.  And I used it to find my elusive content item!

Rowby
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

 
LVL 9

Author Comment

by:Rowby Goren
ID: 40019844
Rowby: Are you open to the idea of a custom script to look for this information in all the tables?

Open in new window


Hi Ray, I missed your solution however Dan's answer got me right to the item id I was looking for!

That was probably the fastest EE response(s) I have had ever!

I think under a minute!

Thanks all!

Rowby
0
 
LVL 35

Expert Comment

by:Dan Craciun
ID: 40019907
I think that if we could see the response times, I'd probably be in top 10, right behind Ozo :)

Glad I could help, Rowby!
0
 
LVL 9

Author Comment

by:Rowby Goren
ID: 40019934
:)
0
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 40019936
Well done, colleagues!
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

It’s a season to be thankful, and we’re thankful for users like you who engage on site, solve technology problems, and network with others in the industry. What tech are we most thankful for? Keep reading.
Laravel is the most sought after web development framework. It comes with ample amount of features that make it easy for developers to work around it. Know about its features in detail.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

579 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