PDA

View Full Version : How to search in sql tables


chacko
9-19-05, 01:33 AM
I use mambo. have a article which dosen't open up due to scripts. I have to search from sql database and deleate the file. can some one xplain how to do it? Plus, if deleating is also a process, kindly explain.

Pig
9-19-05, 10:20 AM
Log into https://phpmyadmin.powweb.com with your database user name and password.
Click on the database name.
Poke around the tables until you find the one that stores these articles. Also note the column name for the titles.
Click on the sql tab.
Enter the following: SELECT * FROM <insert table name> WHERE <insert column name> LIKE '%<insert title fragment>%'
Click the submit button.
You should get a small list back (or maybe just one). Make sure it is the one you want, and click the delete link for that row.