StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>A solution would be to use the <code>information_schema</code> database, to list all database, all tables, all fields, and loop over all that...</p> <p><br> There is this script that could help for at least some part of the work : <a href="http://code.google.com/p/anywhereindb/" rel="nofollow noreferrer">anywhereindb</a> <em>(quoting)</em> :</p> <blockquote> <p>This code is search all the tables and all the rows and columns in a MYSQL Database. The code is written in PHP. For faster result, we are only searching in the varchar field.</p> </blockquote> <p>But, as Harmen noted, this only works with one database -- which means you'd have to wrap something arround it, to loop over each database on your server.</p> <p>For more informations about that, take a look at <a href="http://dev.mysql.com/doc/refman/5.0/en/information-schema.html" rel="nofollow noreferrer">Chapter 19. INFORMATION_SCHEMA Tables</a> ; especially, the <a href="http://dev.mysql.com/doc/refman/5.0/en/schemata-table.html" rel="nofollow noreferrer"><code>SCHEMATA</code></a> table, which contains the name of all databases on the server.</p> <p><br> Here's another solution, based on a stored procedure -- which means less client/server calls, which might make it faster : <a href="http://kedar.nitty-witty.com/miscpages/mysql-search-through-all-database-tables-columns-stored-procedure.php" rel="nofollow noreferrer">http://kedar.nitty-witty.com/miscpages/mysql-search-through-all-database-tables-columns-stored-procedure.php</a></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload