| site links |
|
:: home :: archive :: donate :: rss feed :: about site :: bend forums :: bend blogs :: sh.orty :: welcome to bend |
| advertisements |
|
|
| about |
|
UtterlyBoring.com is produced by Jake Ortman (e-mail, resume), a 30-year-old dad, percussionist, freelance Web designer, consultant and jack-of-all-trades computer geek, living in Bend, Oregon. He created this so that his expensive journalism and technology degree isn't getting totally wasted. In addition to editing this site in his free time, he is the IT Director and Ad Designer at both Sunray and Discover Sunriver. He has LinkedIn, MySpace, Facebook profiles if you're trying to stalk him.
Opinions and comments on this site are the opinions of the author, not the author's employer, family, friends or pets. This site is powered by Movable Type and is hosted by orty.com. Internet connection provided by Bend BroadBand. Since December 1st, 2002, there have been 5270 entries. Visitors to this blog have posted 16543 comments. If you're reading this, you have too much time on your hands. |
| support us |
|
|
Search And Replace in MySQLThis is just mostly for my reference so I don't have to keep digging in the Google cache to get this site: update tablename set field = replace(field,'search_for_this','replace_with_this');I've probably used this bit of SQL a dozen times in the last week while doing some pruning/cleanup in a work database, I just kept forgetting the exact syntax. Posted by Jake on 12/21/05 @ 03:01 PM
Posted in Geekdom | 6 Comments | Permalink Submit to digg, del.icio.us, reddit, or stumbleupon 6 CommentsPatrick said on 12/22/05 @ 08:33 AM:Hmm... interesting. Which db are you cleaning out? Jake said on 12/22/05 @ 08:46 AM: I was using that to make some descriptions consistent in Sunray's online database. Diederick said on 12/23/05 @ 10:49 AM: Thank you very very very very very much. Paul said on 12/23/05 @ 06:36 PM: I didn't know that. Does it only work for MySQL? Jake said on 12/24/05 @ 12:11 AM: Honestly, I have no idea, Paul. I don't use anything but MySQL (though I have Postgres installed on this server for another site, but I'm not about to setup a database just to test it). Diederick said on 12/28/05 @ 01:38 AM: I don't think it's standard SQL Post a comment |
What are you doing down here? Don't you have something better to do? Like Go Back To The Top of the page, or even see who created this site? This site is © 2001 - 2008 by the Utterly Boring folks at UtterlyBoring.com. Steal my content, as I probably did, too, just link to my site or the original site. Batteries not included. One size fits all. Not for off-road use. Not for internal use. Do not taunt Happy Fun Ball. Technorati Profile.
