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

Using Phpmyadmin to search for a field in a table

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
Rowby Goren
Asked:
Rowby Goren
  • 3
  • 2
  • 2
1 Solution
 
Ray PaseurCommented:
Rowby: Are you open to the idea of a custom script to look for this information in all the tables?
0
 
Dan CraciunIT ConsultantCommented:
SELECT * FROM blah_content WHERE 
id = 125 OR asset_id = 125

Open in new window


HTH,
Dan
0
 
Rowby GorenAuthor Commented:
Thanks Dan for that instant response.  And I used it to find my elusive content item!

Rowby
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Rowby GorenAuthor Commented:
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
 
Dan CraciunIT ConsultantCommented:
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
 
Rowby GorenAuthor Commented:
:)
0
 
Ray PaseurCommented:
Well done, colleagues!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

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