asked on

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

Ray Paseur

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

ASKER CERTIFIED SOLUTION

Dan Craciun

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Rowby Goren

ASKER

Thanks Dan for that instant response. And I used it to find my elusive content item!

Rowby

Rowby Goren

ASKER

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

Dan Craciun

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!

Rowby Goren

ASKER

Ray Paseur

Well done, colleagues!