(866) 837-0540
 
 

Internet Marketing and Design Services for Turnkey Web Solutions 

Facebook Twitter Gplus Flickr LinkedIn YouTube Google Maps E-mail RSS
 
 
Home » web development » MySQL » MySQL – Replace Select Text within a Database Field
formats

MySQL – Replace Select Text within a Database Field

Maintaining databases can be a chore, but knowing the appropriate SQL to do the job can save hours of time. Here is a tidbit regarding changing a select string of text within a specific field of a table in a MySQL database. You can edit 1000s of records with this one query:
UPDATE table SET field = REPLACE(field, 'text to be replaced', 'replacement text');

In this example, the table name is “table”, the field to find the text in is named “field”, the rest should be self explanatory.

VN:F [1.9.13_1145]
Rating: 4.0/10 (3 votes cast)
VN:F [1.9.13_1145]
Rating: 0 (from 2 votes)
MySQL - Replace Select Text within a Database Field, 4.0 out of 10 based on 3 ratings
 
Take a piece of the Web from WebPaws.com: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Facebook
  • LinkedIn
  • TwitThis
  • MySpace
  • Google Bookmarks
  • Webnews
  • Digg
  • del.icio.us
  • StumbleUpon
  • eKudos
  • email
  • Fleck
  • Hype
  • MisterWong
  • Print
  • Technorati
  • YahooMyWeb
 
Tags:

One Response

  1. viral marketing is of course the best way to market products on the internet`-*

    VA:F [1.9.13_1145]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.13_1145]
    Rating: 0 (from 0 votes)

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

© Copyright © 1998-2011, WebPaws.com All rights reserved.
credit