[nycphp-talk] MySQL question

Preston-Campbell brian at
Thu Jun 27 12:20:09 EDT 2002

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