<div>
Do you need it as part of an actual search or are you just looking for it this one time?<br />
<br />
If the latter, you can just do a mysqldump on your entire database and look through the results.<br />

<pre><code id="code-396398">mysqldump --extended-insert=0 my_database | less
</code></pre>
</div>


Do you need it as part of an actual search or are you just looking for it this one time?

If the latter, you can just do a mysqldump on your entire database and look through the results.


mysqldump --extended-insert=0 my_database | less


<div>
mysql_list_tables($dbname)<wbr /> will give you the names of every table in the database to which you are connected. &nbsp; <br />
<br />
Do a while loop on that, and within the loop, for each table, mysql_list_fields($dbname,<wbr /> $tablename) will give you every fieldname in that table. &nbsp; <br />
<br />
Do another while loop on that, and within this loop, do a SELECT $fieldname FROM $tablename WHERE $fieldname LIKE '%$string%'<br />
<br />

</div>


mysql_list_tables($dbname) will give you the names of every table in the database to which you are connected.  

Do a while loop on that, and within the loop, for each table, mysql_list_fields($dbname, $tablename) will give you every fieldname in that table.  

Do another while loop on that, and within this loop, do a SELECT $fieldname FROM $tablename WHERE $fieldname LIKE '%$string%'



<div>
I should say, if the former, then not really, no.<br />
<br />
You could maybe do a SELECT .. UNION on *all* of your tables and then specify a WHERE clause with something like CONCAT(table1.col1, table1.col2, table2.col1, table2.col2, ...) LIKE &quot;%string%&quot;<br />
<br />
Not fun to write that query and it will be horribly slow (well, depending on how many tables/columns you have).
</div>


I should say, if the former, then not really, no.

You could maybe do a SELECT .. UNION on *all* of your tables and then specify a WHERE clause with something like CONCAT(table1.col1, table1.col2, table2.col1, table2.col2, ...) LIKE "%string%"

Not fun to write that query and it will be horribly slow (well, depending on how many tables/columns you have).

<div>
<div class="content wysiwyg-content">
Is there a way to find a string through the whole database?
</div>
</div>


Is there a way to find a string through the whole database?

Mysql - Search for string in entire database

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.