Searching a database via command prompt
Moderator: General Moderators
Searching a database via command prompt
I need to do a sweeping search of an entire database for a particular word via the ssh command prompt... is that possible?
Managers
Ha ha, My manager asked me to do that last year.
The only thing I've ever heard to do it is phpmyadmin. You may be able to run that from lynx, i don't know.
You also might try but your database may not store char/varchar columns as text.
hairy problem, that is!
The only thing I've ever heard to do it is phpmyadmin. You may be able to run that from lynx, i don't know.
You also might try
Code: Select all
grep -Hni 'SEARCH_STR'