[nycphp-talk] MySQL question
brian at preston-campbell.com
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 supertom.com>
To: "NYPHP Talk" <talk at nyphp.org>
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?
More information about the talk