Quote:
Originally Posted by job0107
Well, if you think you can come up with a better solution for this particular situation, I would be very interested in seeing it.
Otherwise your criticism is just so much hot air.
Thanks for nothing.
|
I think it's a fine solution, and like Alane said, it
works. What more could anyone want?
I'll take working code over pretty code any day of the week.
Also, FWIW, I don't think carters-site was really criticizing the solution. He may have been a tad inelegant in his response with the word "gross", but I didn't read it as outright criticism. I may be wrong.
Finally, a little late to the party, but I did find this, from Hartmut Holzgraefe:
Regular Expression Functions for MySQL
My Regular Exrepssion UDFs for MySQL have been available on MySQL Forge for a while already, now i've taken the time to create a Trac project page for them. I've implemented the following four functions:
* REGEXP_LIKE(text, pattern [, mode])
* REGEXP_SUBSTR(text, pattern)
* REGEXP_INSTR(text, pattern [,position [,occurence [,return_end [,mode]]]])
* REGEXP_REPLACE(text, pattern, replace)
that behave very similar to their Oracle counterparts, using the same regular expression syntax as the MySQL REGEXP operator.