You won't be able to do this with a simple sql patch, as mySQL doesn't have a capability to replace substrings of data fields.
You'll need to build a php script to do it - the easiest way is to build a new page for admin that does the job.
Take the following code, paste it into a blank text editor file, edit the two numbers in line 11 (first is the old number, second is the new number) and save the file as admin/update_phone.php
**** I highly recommend making a backup of your database before this next step, because I haven't tested this code
Then from any page in admin, just change the url in your browser to www.yoursite.com/admin_path/update_phone.php
When it loads, the page should show xxx product descriptions updated where xxx is equal to your number of products multiplied by the number of languages you are using in your store.
Code:
<?php
require('includes/application_top.php');
$query = "select products_id, language_id, products_description from " . TABLE_PRODUCTS_DESCRIPTION;
$result = $db->Execute($query);
$records = 0;
while (!$result->EOF) {
$new_description = str_replace('01202 123456', '01258 654321', $result->fields['products_description']);
$db->Execute("UPDATE " . TABLE_PRODUCTS_DESCRIPTION . " SET products_description = " . $new_description . "
WHERE products_id = '" . (int)$result->fields['products_id'] . "'
AND language_id = '" . (int)$result->fields['language_id'] . "'");
$records += 1;
$result->MoveNext();
}
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<script language="javascript" src="includes/menu.js"></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
<!-- body_text //-->
<table border="0" width="100%" cellspacing="0" cellpadding="2">
<tr>
<td>
<?php echo $records; ?> product descriptions updated
</td>
</tr>
</table>
<!-- body_text_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
Bookmarks