network profile
| bio | website | TheNubbyAdmin.com |
|---|---|---|
| location | Scottsdale, AZ | |
| age | 30 | |
| visits | member for | 2 years, 2 months |
| seen | Mar 29 at 21:32 | |
| stats | profile views | 3 |
Learn About Me!
I'm a generalist Systems Administrator. I design and implement systems that rely on Windows and Linux servers, wired and wireless networks, storage of all types, and insert_buzzword();
I Am a Bad Person =(
I do not intend to offend, but at times I get carried away with my own humor, puns, and self assigned eloquence. If I offended you publicly, tell me and I will repent publicly.
Hire Me!
I am an independent consultant that owns and operates his own LLC in the US of A. Check out my careers.StackOverflow.com profile or you can find me on LinkedIn.
As a Systems Engineer, I work to enable you and your business to help yourselves through technology with the aid of my analysis, design, and implementation skills.
I can help your business help itself. I will analyze your present state, learn about your hoped-for future and get the two to meet using technology as a framework and excellent workflows as the "meat".
Contact Me!
Gmail / GTalk: Nonapeptide. Feel free to email me, add me in GTalk or follow my Google Reader shared items.
Other IM Networks: Yes. Just ask me.
Twitter: @Nonapeptide
Other
My Gravatar is from Troy Snow's photography. Check him out at his Flickr page and tell him I sent you: http://www.flickr.com/photos/troysnow/ . Even though we tend to use the same goofy kitten face as an avatar, we are not the same person and have no affiliation. Other than good taste in avatars, anyway.
|
Feb 21 |
awarded | Popular Question |
|
Jul 11 |
comment |
CASE statement with IS NULL and NOT NULL Define "better". |
|
Feb 8 |
comment |
Why would an UPDATE SET REPLACE() statement match rows, but change none and give no warnings? Question updated, answer awarded. Thanks for your patience. I'll send some ServerFaulters over to reward your Job-like perseverance with upvotes. =) |
|
Feb 8 |
awarded | Scholar |
|
Feb 8 |
accepted | Why would an UPDATE SET REPLACE() statement match rows, but change none and give no warnings? |
|
Feb 8 |
revised |
Why would an UPDATE SET REPLACE() statement match rows, but change none and give no warnings? added 969 characters in body |
|
Feb 8 |
comment |
Why would an UPDATE SET REPLACE() statement match rows, but change none and give no warnings? I did the terribly un-SysAdmin thing of assuming something to be true. It seemed so unlikely that a URL would have been written with capitalization. I'll go sit in a corner. |
|
Feb 8 |
revised |
Why would an UPDATE SET REPLACE() statement match rows, but change none and give no warnings? added 15 characters in body |
|
Feb 8 |
comment |
Why would an UPDATE SET REPLACE() statement match rows, but change none and give no warnings? Oh. My. GOODNESS. My eyes focused on the returns and finally realized that the URLs in the post content are, for some unholy reason, in camelCase. As in CompanyDomain.com rather than companydomain.com. Right now I think that the WHERE clause is of course returning all possible capitalization permutations of companydomain.com because I'm seeing all 167 rows. I'm also assuming that it's the REPLACE() function that merely needs to have the first companydomain.com changed to CompanyDomain.com - going to search more. |
|
Feb 8 |
comment |
Why would an UPDATE SET REPLACE() statement match rows, but change none and give no warnings? The select query returns 167 rows. It's rather ugly output - HTML. This is the post_content field in the wp_posts table of a Wordpress installation. |
|
Feb 8 |
comment |
Why would an UPDATE SET REPLACE() statement match rows, but change none and give no warnings? Thanks! I looked more into it and think I understand a bit better. However, after researching, thinking I understood and then performing a new statement... it appears that I am not understanding like I thought I was. >_< My question has been updated. |
|
Feb 8 |
revised |
Why would an UPDATE SET REPLACE() statement match rows, but change none and give no warnings? added 541 characters in body |
|
Feb 8 |
awarded | Announcer |
|
Feb 8 |
awarded | Student |
|
Feb 8 |
comment |
Why would an UPDATE SET REPLACE() statement match rows, but change none and give no warnings? Aha, I didn't know that replace couldn't handle wildcards. That gives me something to go on. I'm not sure your statement would work for my exact scenario because I have larger urls like TLD.com/blah/foo.bar that need to be changed to TLD.org/blah/foo.bar. To my untrained SQL eye, it appears that the replace function in your statement will only find strict TLD.com string and replace them with strict TLD.org strings. What I might end up doing is dumping the database and then crunching the text with vim before pulling it back into MySQL. How crazy is that? |
|
Feb 8 |
awarded | Editor |
|
Feb 8 |
revised |
Why would an UPDATE SET REPLACE() statement match rows, but change none and give no warnings? added 36 characters in body |
|
Feb 8 |
asked | Why would an UPDATE SET REPLACE() statement match rows, but change none and give no warnings? |
|
Mar 16 |
awarded | Autobiographer |
|
Mar 16 |
awarded | Supporter |
