[thelist] SQL SELECT and RegEx

Jeffrey Barke jeffrey.barke at themechanism.com
Wed Dec 12 14:06:54 CST 2007

Not sure about RegEx, but if it's always the same HTML tag, you can  
use MySQL's REPLACE() function.


Jeffrey Barke
jeffrey.barke at theMechanism.com
Lead Developer, US
theMechanism - New York City
440 9th Avenue, 8th Floor
New York, NY 10001-1631
t: +1 212.404.3150
c: +1 917.941.1232
f: +1 212.404.3228


Subscribe to theMechcast, our monthly Podcast:

theMechanism - London
3rd Floor
405 The Strand
London E14 9FW
United Kingdom
t: +44 (0)20 7240 4964
f: +44 (0)20 7240 2262

The information contained in this Electronic mail message is attorney  
privileged and confidential information intended only for the use of  
the individual or entity named above. Such information also is  
intended to be privileged, confidential, and exempt from disclosure  
under applicable law. If the reader of this message is not the  
intended recipient or the employee or agent responsible to deliver it  
to the intended recipient, you are hereby notified that any  
dissemination, distribution, or copying of this communication is  
strictly prohibited. If you have received this communication in  
error, please notify us immediately by telephone.

Blah, blah, blah...

On Dec 12, 2007, at 2:45 PM, Chris Dempsey wrote:

> Hi,
> Is it possible to run an SQL SELECT statement and apply a regular  
> expression
> to a field that will manipulate the data returned at the time of  
> running the
> I appreciate that I may be phrasing my question incorrectly but  
> what I want
> to achieve is to pull a list of product names from the database and  
> use
> RegEx to strip a specific HTML tag from each record.
> I know that I could strip the tags out at the time of looping  
> through the
> recordset and writing the product names to screen but this is not  
> feasible
> in this case [I need to tweak a pre-built shopping cart but don't  
> want to go
> through thousands of lines of code if it can be done on the SLECT
> statement].
> I've asked Google but am not finding anything that tells me if this  
> is even
> possible, never mind examples of how it might be done.
> Thanks,
> Chris.
> Ps.  The bad news is it's Access not MS SQL or MySQL.
> -- 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !

More information about the thelist mailing list