[V4MD] LIKE search

[Martin Wright]

I'm not too familiar with RegEx. Is this the only way to do wildcard searches?
If so, where can I find some examples?
I've given example of the current SQL below.


SELECT *
FROM tbl_subsections, tbl_chapters 
WHERE (((tbl_subsections.subsection_name <> 'ss1') 
	AND (tbl_subsections.subsection_type <> 'bibliography')) 
	AND ((tbl_subsections.content_xml LIKE 'dermis' no_case))) 
ORDER BY tbl_chapters.chapter_num, tbl_subsections.heading_txt 

I need to search for the exact term 'dermis' unless the user types in 'dermis*'.

Thanks
Martin



 

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of 
> Ruslan Zasukhin
> Sent: 27 April 2006 15:28
> To: valentina at lists.macserve.net
> Subject: Re: [V4MD] LIKE search
> 
> On 4/27/06 5:18 PM, "Martin Wright" <martin at kinetix.co.uk> wrote:
> 
> > Hi
> > 
> > There many instances of the word 'physicians' but not 
> necessarily at 
> > the end of a line, simply within the text.
> > 
> > Maybe I should explain what I need to do.
> > 
> > The field I need to search is a text field which is indexed by word.
> > The user can type in the search term. The search much 
> search for exact 
> > matches of the word by default. For example, searching for 
> > 'physicians' will find some results, whereas 'physici' 
> should not find 
> > any results.
> > 
> > If the user wishes, they can use a wildcard in the search, such as 
> > 'physic*', which would return many results.
> > 
> > Is this possible with V1?
> 
> I believe that in REGEX exists anchors for WORD boundary.
> 
>     it seems this is \b
> 
> Please check file Syntax of RegEx in your V4MD archive
> 
> --
> Best regards,
> 
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
> 
> Valentina - Joining Worlds of Information http://www.paradigmasoft.com
> 
> [I feel the need: the need for speed]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
> 
>