blocks|key|1409229|text|一个简单的解决方案是这样做：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1409230|mysqldump+-u+myuser+--no-create-info+--extended-insert=FALSE+databasename+%7C+grep+-i+"<search+string>"|code-block|syntax|javascript|1409231|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

A simple solution would be doing something like this:

<pre class="lang-sh prettyprint-override"><code>mysqldump -u myuser --no-create-info --extended-insert=FALSE databasename | grep -i "&lt;search string&gt;"
</code></pre>

blocks|key|1624043|text|以前的帖子我知道，但对于像我这样通过谷歌找到这篇文章的人来说，如果你安装了phpmyadmin，它有一个全局搜索功能。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1624044|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Old post I know, but for others that find this via Google like I did, if you have phpmyadmin installed, it has a global search feature.

blocks|key|1624518|text|使用MySQL工作台，您可以从“数据库”->“搜索表数据”菜单选项中搜索字符串。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1624519|指定LIKE+%25URL_TO_SEARCH%25，并在左侧选择要搜索的所有表。您可以使用"Cntrl+%2B+A“选择左侧的整个树，然后取消选择您不关心的对象。|1624520|​|1624521|📷|atomic|offset|length|1624522|1624523|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/1b9755e3f52a0b668eebc30720234f67.png|imageAlt^0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@$I|Y|J|Z|1|10]]|A|$]]|$1|K|3|E|5|6|7|11|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S|T|-4]]]]

Using the MySQL Workbench, you can search for a string from the "Database" -> "Search Table Data" menu option. 

Specify LIKE %URL_TO_SEARCH% and on the left side select all the tables you want to search through. You can use "Cntrl + A" to select the whole tree on the left, and then deselect the objects you don't care about.

<img src="https://i.stack.imgur.com/2Ze3J.png" alt="enter image description here">

blocks|key|1624167|text|当我们在Wordpress网站上更换域名时，我自己也在寻找这个。没有一些编程是无法完成的，所以这就是我所做的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1624168|<?php++
++header("Content-Type:+text/plain");

++$host+=+"localhost";
++$username+=+"root";
++$password+=+"";
++$database+=+"mydatabase";
++$string_to_replace++=+'old.example.com';
++$new_string+=+'new.example.com';

++//+Connect+to+database+server
++mysql_connect($host,+$username,+$password);

++//+Select+database
++mysql_select_db($database);

++//+List+all+tables+in+database
++$sql+=+"SHOW+TABLES+FROM+".$database;
++$tables_result+=+mysql_query($sql);

++if+(!$tables_result)+{
++++echo+"Database+error,+could+not+list+tables\nMySQL+error:+"+.+mysql_error();
++++exit;
++}

++echo+"In+these+fields+'$string_to_replace'+have+been+replaced+with+'$new_string'\n\n";
++while+($table+=+mysql_fetch_row($tables_result))+{
++++echo+"Table:+{$table[0]}\n";
++++$fields_result+=+mysql_query("SHOW+COLUMNS+FROM+".$table[0]);
++++if+(!$fields_result)+{
++++++echo+'Could+not+run+query:+'+.+mysql_error();
++++++exit;
++++}
++++if+(mysql_num_rows($fields_result)+>+0)+{
++++++while+($field+=+mysql_fetch_assoc($fields_result))+{
++++++++if+(stripos($field['Type'],+"VARCHAR")+!==+false+%7C%7C+stripos($field['Type'],+"TEXT")+!==+false)+{
++++++++++echo+"++".$field['Field']."\n";
++++++++++$sql+=+"UPDATE+".$table[0]."+SET+".$field['Field']."+=+replace(".$field['Field'].",+'$string_to_replace',+'$new_string')";
++++++++++mysql_query($sql);
++++++++}
++++++}
++++++echo+"\n";
++++}
++}

++mysql_free_result($tables_result);++
?>|code-block|syntax|javascript|1624169|希望它能帮助将来遇到这个问题的任何人:)|1624170|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I was looking for this myself when we changed domain on our Wordpress website. It can't be done without some programming so this is what I did.

<pre><code>&lt;?php 
 header("Content-Type: text/plain");

 $host = "localhost";
 $username = "root";
 $password = "";
 $database = "mydatabase";
 $string_to_replace = 'old.example.com';
 $new_string = 'new.example.com';

 // Connect to database server
 mysql_connect($host, $username, $password);

 // Select database
 mysql_select_db($database);

 // List all tables in database
 $sql = "SHOW TABLES FROM ".$database;
 $tables_result = mysql_query($sql);

 if (!$tables_result) {
 echo "Database error, could not list tables\nMySQL error: " . mysql_error();
 exit;
 }

 echo "In these fields '$string_to_replace' have been replaced with '$new_string'\n\n";
 while ($table = mysql_fetch_row($tables_result)) {
 echo "Table: {$table[0]}\n";
 $fields_result = mysql_query("SHOW COLUMNS FROM ".$table[0]);
 if (!$fields_result) {
 echo 'Could not run query: ' . mysql_error();
 exit;
 }
 if (mysql_num_rows($fields_result) &gt; 0) {
 while ($field = mysql_fetch_assoc($fields_result)) {
 if (stripos($field['Type'], "VARCHAR") !== false || stripos($field['Type'], "TEXT") !== false) {
 echo " ".$field['Field']."\n";
 $sql = "UPDATE ".$table[0]." SET ".$field['Field']." = replace(".$field['Field'].", '$string_to_replace', '$new_string')";
 mysql_query($sql);
 }
 }
 echo "\n";
 }
 }

 mysql_free_result($tables_result); 
?&gt;
</code></pre>

Hope it helps anyone who's stumbling into this problem in the future :)

blocks|key|1624265|text|SQLyog是一种基于图形用户界面的解决方案，用于解决跨所有列、表和数据库的数据搜索问题。用户可以自定义搜索，将其限制为字段、表和数据库。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1624266|在它的Data+Search功能中，人们可以像使用谷歌一样搜索字符串。|style|CODE|1624267|​|1624268|📷|atomic|1624269|1624270|entityMap|0|LINK|mutability|MUTABLE|url|http://www.webyog.com/en/downloads.php|1|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/f68b6a4205d8c878d0802dfb6c84bb4b.png|imageAlt^0|0|6|0|0|3|B|0|0|0|1|1|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@$A|12|B|13|1|14]]|C|$]]|$1|D|3|E|5|6|7|15|8|@$A|16|B|17|F|G]]|9|@]|C|$]]|$1|H|3|I|5|6|7|18|8|@]|9|@]|C|$]]|$1|J|3|K|5|L|7|19|8|@]|9|@$A|1A|B|1B|1|1C]]|C|$]]|$1|M|3|I|5|6|7|1D|8|@]|9|@]|C|$]]|$1|N|3|-4|5|6|7|1E|8|@]|9|@]|C|$]]]|O|$P|$5|Q|R|S|C|$T|U]]|V|$5|W|R|X|C|$Y|Z|10|-4]]]]

<a href="http://www.webyog.com/en/downloads.php" rel="nofollow noreferrer">SQLyog</a> is GUI based solution to the problem of data search across all columns, tables and databases. One can customize search restricting it to field, table and databases.

In its <code>Data Search</code> feature one can search for strings just like one uses Google.

<img src="https://i.stack.imgur.com/l0Oyu.png" alt="SQLyog Datasearch screenshot">

blocks|key|1624604|text|MikeW提出了一个有趣的解决方案，但正如评论中所提到的，它是SQL+Server解决方案，而不是MySQL解决方案。这是一个MySQL解决方案：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1624605|use+information_schema;
set+@q+=+'Boston';
set+@t+=+'my_db';

select+CONCAT('use+\'',@q,'\';')+as+q+UNION
select+CONCAT('select+\'',+tbl.`TABLE_NAME`,'\'+as+TableName,+\'',+col.`COLUMN_NAME`,'\'+as+Col,+`',col.`COLUMN_NAME`,'`+as+value++from+`'+,+tbl.`TABLE_NAME`,'`+where+`'+,
++++++++col.`COLUMN_NAME`+,+'`+like+\'%25'+,@q,++'%25\'+UNION')+AS+q
from+`tables`+tbl
inner+join+`columns`+col+on+tbl.`TABLE_NAME`+=+col.`TABLE_NAME`and+col.DATA_TYPE='varchar'
where+tbl.TABLE_SCHEMA++=++@t++;|code-block|syntax|javascript|1624606|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

MikeW presented an interesting solution, but as mentioned in comments, it's a SQL Server solution not a MySQL solution. Here is a MySQL solution:

<pre><code>use information_schema;
set @q = 'Boston';
set @t = 'my_db';

select CONCAT('use \'',@q,'\';') as q UNION
select CONCAT('select \'', tbl.`TABLE_NAME`,'\' as TableName, \'', col.`COLUMN_NAME`,'\' as Col, `',col.`COLUMN_NAME`,'` as value from `' , tbl.`TABLE_NAME`,'` where `' ,
 col.`COLUMN_NAME` , '` like \'%' ,@q, '%\' UNION') AS q
from `tables` tbl
inner join `columns` col on tbl.`TABLE_NAME` = col.`TABLE_NAME`and col.DATA_TYPE='varchar'
where tbl.TABLE_SCHEMA = @t ;
</code></pre>

blocks|key|1624109|text|我不记得我是在哪里遇到这个脚本的，但我一直在用它和XCloner一起移动我的WP多站点。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1624110|<?php

++++//+Setup+the+associative+array+for+replacing+the+old+string+with+new+string
++++$replace_array+=+array(+'FIND'+=>+'REPLACE',+'FIND'+=>+'REPLACE');

++++$mysql_link+=+mysql_connect(+'localhost',+'USERNAME',+'PASSWORD'+);
++++if(+!+$mysql_link)+{
++++++++die(+'Could+not+connect:+'+.+mysql_error()+);
++++}

++++$mysql_db+=+mysql_select_db(+'DATABASE',+$mysql_link+);
++++if(!+$mysql_db+)+{
++++++++die(+'Can\'t+select+database:+'+.+mysql_error()+);
++++}

++++//+Traverse+all+tables
++++$tables_query+=+'SHOW+TABLES';
++++$tables_result+=+mysql_query(+$tables_query+);
++++while(+$tables_rows+=+mysql_fetch_row(+$tables_result+)+)+{
++++++++foreach(+$tables_rows+as+$table+)+{

++++++++++++//+Traverse+all+columns
++++++++++++$columns_query+=+'SHOW+COLUMNS+FROM+'+.+$table;
++++++++++++$columns_result+=+mysql_query(+$columns_query+);
++++++++++++while(+$columns_row+=+mysql_fetch_assoc(+$columns_result+)+)+{

++++++++++++++++$column+=+$columns_row['Field'];
++++++++++++++++$type+=+$columns_row['Type'];

++++++++++++++++//+Process+only+text-based+columns
++++++++++++++++if(+strpos(+$type,+'char'+)+!==+false+%7C%7C+strpos(+$type,+'text'+)+!==+false+)+{
++++++++++++++++++++//+Process+all+replacements+for+the+specific+column++++++++++++++++++++
++++++++++++++++++++foreach(+$replace_array+as+$old_string+=>+$new_string+)+{
++++++++++++++++++++++++$replace_query+=+'UPDATE+'+.+$table+.+
++++++++++++++++++++++++++++'+SET+'+.++$column+.+'+=+REPLACE('+.+$column+.+
++++++++++++++++++++++++++++',+\''+.+$old_string+.+'\',+\''+.+$new_string+.+'\')';
++++++++++++++++++++++++mysql_query(+$replace_query+);
++++++++++++++++++++}
++++++++++++++++}
++++++++++++}
++++++++}
++++}

++++mysql_free_result(+$columns_result+);
++++mysql_free_result(+$tables_result+);
++++mysql_close(+$mysql_link+);

++++echo+'Done!';

?>|code-block|syntax|javascript|1624111|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I can't remember where I came across this script, but I've been using it with XCloner to move my WP multisites.

<pre><code>&lt;?php

 // Setup the associative array for replacing the old string with new string
 $replace_array = array( 'FIND' =&gt; 'REPLACE', 'FIND' =&gt; 'REPLACE');

 $mysql_link = mysql_connect( 'localhost', 'USERNAME', 'PASSWORD' );
 if( ! $mysql_link) {
 die( 'Could not connect: ' . mysql_error() );
 }

 $mysql_db = mysql_select_db( 'DATABASE', $mysql_link );
 if(! $mysql_db ) {
 die( 'Can\'t select database: ' . mysql_error() );
 }

 // Traverse all tables
 $tables_query = 'SHOW TABLES';
 $tables_result = mysql_query( $tables_query );
 while( $tables_rows = mysql_fetch_row( $tables_result ) ) {
 foreach( $tables_rows as $table ) {

 // Traverse all columns
 $columns_query = 'SHOW COLUMNS FROM ' . $table;
 $columns_result = mysql_query( $columns_query );
 while( $columns_row = mysql_fetch_assoc( $columns_result ) ) {

 $column = $columns_row['Field'];
 $type = $columns_row['Type'];

 // Process only text-based columns
 if( strpos( $type, 'char' ) !== false || strpos( $type, 'text' ) !== false ) {
 // Process all replacements for the specific column 
 foreach( $replace_array as $old_string =&gt; $new_string ) {
 $replace_query = 'UPDATE ' . $table . 
 ' SET ' . $column . ' = REPLACE(' . $column . 
 ', \'' . $old_string . '\', \'' . $new_string . '\')';
 mysql_query( $replace_query );
 }
 }
 }
 }
 }

 mysql_free_result( $columns_result );
 mysql_free_result( $tables_result );
 mysql_close( $mysql_link );

 echo 'Done!';

?&gt;
</code></pre>

blocks|key|1409900|text|如果您可以使用bash+-这里有一个脚本:它需要数据库上有一个带有pass+dbread的用户dbread。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1409901|#!/bin/bash
IFS='
'
DBUSER=dbread
DBPASS=dbread
echo+-n+"Which+database+do+you+want+to+search+in+(press+0+to+see+all+databases):+"+
read+DB
echo+-n+"Which+string+do+you+want+to+search:+"+
read+SEARCHSTRING
for+i+in+`mysql+$DB+-u$DBUSER+-p$DBPASS+-e+"show+tables"+%7C+grep+-v+\`mysql+$DB+-u$DBUSER+-p$DBPASS+-e+"show+tables"+%7C+head+-1\``
do
for+k+in+`mysql+$DB+-u$DBUSER+-p$DBPASS+-e+"desc+$i"+%7C+grep+-v+\`mysql+$DB+-u$DBUSER+-p$DBPASS+-e+"desc+$i"+%7C+head+-1\`+%7C+grep+-v+int+%7C+awk+'{print+$1}'`
do
if+[+`mysql+$DB+-u$DBUSER+-p$DBPASS+-e+"Select+*+from+$i+where+$k='$SEARCHSTRING'"+%7C+wc+-l`+-gt+1+]
then
echo+"+Your+searchstring+was+found+in+table+$i,+column+$k"
fi
done
done|code-block|syntax|javascript|1409902|如果有人想要一个解释：http://infofreund.de/?p=1670|offset|length|1409903|entityMap|0|LINK|mutability|MUTABLE|url|http://infofreund.de/?p=1670^0|0|0|B|S|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

If you can use a bash - here is a script:
It needs a user dbread with pass dbread on the database.

<pre><code>#!/bin/bash
IFS='
'
DBUSER=dbread
DBPASS=dbread
echo -n "Which database do you want to search in (press 0 to see all databases): " 
read DB
echo -n "Which string do you want to search: " 
read SEARCHSTRING
for i in `mysql $DB -u$DBUSER -p$DBPASS -e "show tables" | grep -v \`mysql $DB -u$DBUSER -p$DBPASS -e "show tables" | head -1\``
do
for k in `mysql $DB -u$DBUSER -p$DBPASS -e "desc $i" | grep -v \`mysql $DB -u$DBUSER -p$DBPASS -e "desc $i" | head -1\` | grep -v int | awk '{print $1}'`
do
if [ `mysql $DB -u$DBUSER -p$DBPASS -e "Select * from $i where $k='$SEARCHSTRING'" | wc -l` -gt 1 ]
then
echo " Your searchstring was found in table $i, column $k"
fi
done
done
</code></pre>

If anyone wants an explanation: <a href="http://infofreund.de/?p=1670" rel="nofollow">http://infofreund.de/?p=1670</a>

blocks|key|1409195|text|Scott给出了一个很好的例子来说明如何做到这一点，但问题是你为什么要这样做？如果需要对特定字符串执行查找和替换，还可以尝试对数据库执行mysqldump，在编辑器中执行查找和替换，然后重新加载数据库。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1409196|也许如果你给出一些你想要实现的背景，其他人也许能提供更好的答案。|1409197|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Scott gives a good example of how to do it, but the question is why would you want to? If you need to do a find-and-replace on a specific string, you could also try doing a mysqldump of your database, do a find-and-replace in an editor, then re-load the database.

Maybe if you gave some background on what you are trying to achieve, others might be able to provide better answers.

blocks|key|1623995|text|我正在寻找同样的东西，但是找不到，所以我用PHP写了一个小脚本，你可以在：http://tequilaphp.wordpress.com/2010/07/05/searching-strings-in-a-database-and-files/上找到它。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1623996|祝好运!(我删除了一些私有代码，如果我在这个过程中没有破坏它，请告诉我:D)|1623997|entityMap|0|LINK|mutability|MUTABLE|url|http://tequilaphp.wordpress.com/2010/07/05/searching-strings-in-a-database-and-files/^0|11|2D|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

I was looking for the same but couldn't find it, so I make a small script in PHP, you can find it at:
<a href="http://tequilaphp.wordpress.com/2010/07/05/searching-strings-in-a-database-and-files/" rel="nofollow noreferrer">http://tequilaphp.wordpress.com/2010/07/05/searching-strings-in-a-database-and-files/</a>

Good luck!
(I remove some private code, let me know if I didn't break it in the process :D)

blocks|key|1409652|text|这个视频的前30秒展示了如何使用Phpmyadmin的全局搜索功能，它是有效的。它将在每个表中搜索字符串。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1409653|http://www.vodahost.com/vodatalk/phpmyadmin-setup/62422-search-database-phpmyadmin.html|offset|length|1409654|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|2F|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@$D|O|E|P|1|Q]]|A|$]]|$1|F|3|-4|5|6|7|R|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|C]]]]

The first 30 seconds of this video shows how to use the global search feature of Phpmyadmin
and it works. it will search every table for a string.

<a href="http://www.vodahost.com/vodatalk/phpmyadmin-setup/62422-search-database-phpmyadmin.html" rel="nofollow">http://www.vodahost.com/vodatalk/phpmyadmin-setup/62422-search-database-phpmyadmin.html</a>

blocks|key|1624403|text|在unix机器上，如果数据库不是太大：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1624404|mysqldump+-u+<username>+-p+<password>+<database_name>+--extended=FALSE+%7C+grep+<String+to+search>+%7C+less+-S|code-block|syntax|javascript|1624405|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

In unix machines, if the database is not too big:

<pre><code>mysqldump -u &lt;username&gt; -p &lt;password&gt; &lt;database_name&gt; --extended=FALSE | grep &lt;String to search&gt; | less -S
</code></pre>

blocks|key|1623693|text|这不是一个优雅的解决方案，但您可以使用嵌套循环结构来实现它|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1623694|//+select+tables+from+database+and+store+in+an+array

//+loop+through+the+array
foreach+table+in+database
{
++++//+select+columns+in+the+table+and+store+in+an+array

++++//+loop+through+the+array
++++foreach+column+in+table
++++{
++++++++//+select+*+from+table+where+column+=+url
++++}
}|code-block|syntax|javascript|1623695|通过在构建列数组时检查哪些列包含字符串，以及将每个表的所有列合并到一个巨大的逗号分隔的WHERE子句中，可以加快速度。|1623696|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Not an elegant solution, but you could achieve it with a nested looping structure

<pre><code>// select tables from database and store in an array

// loop through the array
foreach table in database
{
 // select columns in the table and store in an array

 // loop through the array
 foreach column in table
 {
 // select * from table where column = url
 }
}
</code></pre>

You could probably speed this up by checking which columns contain strings while building your column array, and also by combining all the columns per table in one giant, comma-separated WHERE clause.

I'm trying to figure out how to locate all occurrences of a url in a database. I want to search all tables and all fields. But I have no idea where to start or if it's even possible.

Search for all occurrences of a string in a mysql database

我正在尝试找出如何在数据库中找到所有出现的url。我想搜索所有的表和字段。但我不知道从哪里开始，甚至不知道这是否可能。

问在mysql数据库中搜索字符串的所有匹配项
EN

回答 13

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在mysql数据库中搜索字符串的所有匹配项EN

回答 13

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在mysql数据库中搜索字符串的所有匹配项
EN