Using Phpmyadmin to search for a field in a table
Posted on 2014-04-24
i am somewhat familiar with phpmyadmin
Using Phpmyadmin phpMyAdmin - 126.96.36.199 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.