Solved

Using Phpmyadmin to search for a field in a table

Posted on 2014-04-24
8
443 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
8 Comments
 
LVL 109

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 34

Accepted Solution

by:
Dan Craciun earned 500 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
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 34

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 109

Expert Comment

by:Ray Paseur
ID: 40019936
Well done, colleagues!
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Foreword (July, 2015) Since I first wrote this article, years ago, a great many more people have begun using the internet.  They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
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 …

809 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