RE: Pattern matching queries

2001-08-12 Thread Joe Sheble \(Wizaerd\)
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

Re: Pattern matching queries

2001-08-12 Thread Jeremy Zawodny
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 href="http://www.photoshopuser.com>this website" > > and the query would be:

RE: Pattern matching queries

2001-08-12 Thread Joe Sheble \(Wizaerd\)
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 http://www.photoshopuser.com>this website" and the query would be: WHERE somefield like '%photoshop%' the above record should not be returned. > -Orig

Re: Pattern matching queries

2001-08-12 Thread Jeremy Zawodny
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 ke

Re: Pattern matching queries

2001-08-12 Thread oltra jean-michel
> (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