UPDATE query
| From: | Ron Piggott | Date: | Tue, 08 Mar 2011 16:16:14 +0000 |
| Subject: | UPDATE query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-47711@lists.php.net to get a copy of this message | ||
I am wondering if there is a way to do an UPDATE query where only some of the text changes.
The column I need to modify is named “toll_free”
What I need to search for is: 800-
I need it to replace it with is 1-800-
- BUT I don’t want to change instances of 1-800-
- I need to leave the rest of the toll free phone number in tact.
Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info