User Comments

Nice! Unfortunatelly, it’s non-standard. Can anyone point out an alternative which would work on IBM DB2, Oracle, or MS SQL Server? I imagine these have dedicated stored procedures that pretty much apply regexps to exact field.

Here’s how to do search-and-replace in:

MS-SQL & Sybase, it might be possible to tailor this for other databases.

Very cool! I’m just learning a little bit of SQL now and then, and I love how it’s such a simple syntax. I’m sure you all read the t-shirt “select * from USERS where CLUE > 0” — the cool thing is, in the right DB that would actually do something!

In other comments, I love your slight website revamp! It’s so rare to see a good use of purple, and I love the green link color. And sIFR also? Very cool — is that font VTCorona?

I’m just learning a little bit of SQL now and then, and I love how it’s such a simple syntax.

It is simple and there are some great shortcuts too (although some of them might be database specific). For example, I use MySQL’s date parsing, time-spanning and mathematical functions a heck of a lot, simply because it’s easier (and quicker) to do them at the database rather than in my application.

I love that fact that I can store numerical timestamps in the database yet extract them as english date strings (eg: from “20050124093754” MySQL can yield “Tuesday, 24th January, 2005 @ 09:37” - that’s cool!)

“select * from USERS where CLUE > 0”

I actually used to have that shirt (bought from thinkgeek.com).

I also like the tagline on Jeremy Zawodny’s Weblog: “SELECT * FROM random_thoughts ORDER BY date DESC”.

I love your slight website revamp!

Hey thanks Joen. I’ve encountered mixed opinions on this revision. I’ll admit I was very unsure about the green/purple combo at first, but I’m really lovin’ it now.

And sIFR also? Very cool - is that font VTCorona?

No. It’s “Apoplex”, which I found on the “Old Typewriter Fonts” website. I new I wanted a “typewriter” font but it took a while to find one I was happy with. I think Apoplex is gorgeous.

If anyone comes across a search & replace with regexp for mysql please email me. In fact my requirement is to filter out non-ascii characters from mysql database fields

zzapper

NOTE: This comment has been edited by its author! Additions are shown in italics, deletions with a strike-through.

Thanks for this info - simple to use and it works well for mass field data updates in MySQL.

Hey, I searched for how to search and replace in MySQL, and this came up. The perfect solution for updating a slew of outdated links in old Wordpress posts.

Thanks!

This is the perfect quick fix I needed during a site move from XML to MySQL. Cheers!