MySQL搜索和替换为WILDCARDS-查询 [英] MySQL Search & Replace with WILDCARDS - Query

问题描述

在兑现通配符的同时可以执行MySQL搜索并替换吗?

Is it possible to perform a MySQL search and replace while honoring wildcards?

例如:

$search = "id='%wildcard%-houselisting-rental'>";
$replace = "class='house_rentals'>";
$query = "UPDATE tables SET field = replace(field,'$search','$replace')";
$result = mysql_query($query);

我非常感谢您提供有关此主题的任何建议 -h

I appreciate any advise on the subject -h

推荐答案

我发现这对于mysql是不可能的.

I found out this wasn't possible for mysql.

这篇关于MySQL搜索和替换为WILDCARDS-查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！