[nycphp-talk] MySQL question

tom at tom at
Thu Jun 27 13:18:26 EDT 2002

That is a very good idea!  I will give that a try!



-----Original Message-----
From: Preston-Campbell [mailto:brian at]
Sent: Thursday, June 27, 2002 12:20 PM
To: NYPHP Talk
Subject: Re: [nycphp-talk] MySQL question

it is possible to use regex in MySQL queries so you could eliminate anything
between < and > for example.

MySQL by Paul Dubois covers this subject quite well.


----- Original Message -----
From: <tom at>
To: "NYPHP Talk" <talk at>
Sent: Thursday, June 27, 2002 10:29 AM
Subject: [nycphp-talk] MySQL question

> I know this is off topic as it is a MySQL question, but I figured that
> PHP list may have the answer (I'm using PHP, if that helps!).
> I'm storing both HTML and text in a field, and I now want to search that
> field.  My question is: Is it possible to have MySQL ignore the HTML
> somehow?  I know that I could grab the data out of the db, then use PHP's
> strip_tags and find the text that way, but that takes the performance
> benefits of the db right out of the equation.
> An example of this would be:
> If the user searches for the word 'size', I don't want them pulling back a
> row that contains '<font size=3>'
> Any suggestions on how to do this with just MySQL?
> Thanks,
> Tom

More information about the talk mailing list