PHP Classes

PHP Search MySQL Tables: Search for text in all tables of a MySQL database

Recommend this page to a friend!
  Info   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 44%Total: 3,188 All time: 1,113 This week: 122Up
Version License PHP version Categories
search-mysql-tables 1Free For Educatio...4Databases, Tools, Searching


This class can be used to search for text in all tables of MySQL databases.

It can retrieve the list of tables and fields of a one or more MySQL databases.

The class can execute queries to perform searches for a given keyword in any of the fields of all records of all tables of the specified databases.

Innovation Award
PHP Programming Innovation award winner
May 2010

Prize: One license of ScriptCase Enterprise edition
Sometimes you need to find where in a database it was stored a certain text but you do not know which fields of what tables may contain that text.

This class implements a brute force solution to search for a given text in all fields of all tables of a MySQL database.

Manuel Lemos
Picture of Er. Rochak Chauhan
  Performance   Level  
Name: Er. Rochak Chauhan is available for providing paid consulting. Contact Er. Rochak Chauhan .
Classes: 54 packages by
Country: India India
Age: 45
All time rank: 21 in India India
Week rank: 12 Down1 in India India Equal
Innovation award
Innovation award
Nominee: 15x

Winner: 3x


search string from whole databse mysql
would like to search in whole database a string

  Files folder image Files  
File Role Description
Accessible without login Plain text file example.php Example Example Script
Plain text file Class 100

 Version Control Unique User Downloads Download Rankings  
This week:0
All time:1,113
This week:122Up
 User Ratings  
 All time