On Sat, Aug 11, 2001 at 10:54:58PM -0700, Joe Sheble (Wizaerd) wrote:
I have a text field that contains some plain text intermingled with
html tags. In querying the database, if the keyword I'm searching
for falls within the plain text, that record should be returned.
However, if the
an example would be:
this is some text that would fall within the text field (somefield):
if you want to see some nice images, check out a
href=http://www.photoshopuser.comthis website/a
and the query would be:
WHERE somefield like '%photoshop%'
the above record should not be returned.
On Sun, Aug 12, 2001 at 11:43:31PM -0700, Joe Sheble (Wizaerd) wrote:
an example would be:
this is some text that would fall within the text field (somefield):
if you want to see some nice images, check out a
href=http://www.photoshopuser.comthis website/a
and the query would be:
Then yes, it should be returned.
-Original Message-
On Sun, Aug 12, 2001 at 11:43:31PM -0700, Joe Sheble (Wizaerd) wrote:
an example would be:
this is some text that would fall within the text field (somefield):
if you want to see some nice images, check out a
(REGEXP).
I have a text field that contains some plain text intermingled with html
tags. In querying the database, if the keyword I'm searching for falls
within the plain text, that record should be returned. However, if the
keyword falls within an html tag, it should not be returned.