mySQL guru?

[Ted]

Tony,

Are you trying to remove all posts containing that text string, or just find-and-replace a certain string within the posts?

If it's the latter, I think this is your ticket:

update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

[Ted]

update ORHTable set ORHBrain = replace(ORHBrain,'sobriety','intoxication');

call moderate(hic);

[Tony W]

actually Ted, I'm trying to remove a string, but I've got be selective. I'll email you the strings to keep and the ones to delete. They are all contained in the BODY field of a table.

[Ted]

I'm an expert of search-and-replace strategy. You may need to do a particular sequence in order to not change what things that don't need changing.

BTW: I noticed that in the social networking icons there's a link to Slashdot (). As far as I'm concerned, that means it's open season for geek talk on Songcrafters.  Ain't that right, 64G?

[Tony W]

Open season for Geek Talk! I love it. I'm getting sucked into a rabbit hole with the geek world. I've purchased several "dummies" books to include PHP/mySQL for Dummies... etc.

Instead of reading the book, I glean information, then look for somebody else to do what I want done for me.

That's exactly the kind of dependence that drove me to buy the book in the first place. I'm stuck in a cycle of discovery. I discover something can be done, then search for who's already done it, and if I can glean their code. If I can't find that, I do the next best thing.... find somebody else who has already been where I am and CAN generate code.

[64Guitars]

I don't use social networking sites at all, so I don't know anything about the slashdot and other icons at the top of the page. Those were added by Pedro. In any case, it's not open season for tech talk. Although I like tech talk myself, I'm sure that the vast majority of our members are not the least bit interested. Let's try to stay focused on recording and songwriting. There are dozens of other forums that focus on MySQL and other tech subjects. They would be a better place for this type of discussion and you'd find a lot more people with the knowledge you seek.

Have you tried Google? This simple search turned up lots of sites that would seem to answer your question.

[Tony W]

Interesting slap on the wrist, especially the wording, but point taken. Feel free to lock or archive this thread.

By the way I asked here because I trust The IT guys on the site. I know I won't get led astray.

[64Guitars]

Yes, I'm aware that General Discussion is for anything that doesn't fit in the other boards. But the site is about recording and songwriting and we should try to limit our discussions to related topics. Sure, we'll occasionally get a post here that's completely off-topic. That's okay to a point, especially if it's a topic that might be of general interest to our members such as a news event, for example. But I think that specialised topics such as MySQL are of no interest to the vast majority of our members and there are many more suitable forums elsewhere on the web, so we should avoid such discussions here.

[Tony W]

Thanks for the clarification 64, I appreciate it.

[Ted]

I noticed that in the social networking icons there's a link to Slashdot (). As far as I'm concerned, that means it's open season for geek talk on Songcrafters.  Ain't that right, 64G?

This might have been one of those times when an emoticon would have been useful.  Perhaps winky here  at the end of that sentence would have meant, "Of course I'm kidding," and assured anyone that (after 1200+) posts I really am aware of the purpose of this forum, and also that I am aware that there are other forums on the Web for MySQL and other tech subjects.

My aversion to emoticons has gotten me into trouble a few times recently.