Kinook Software Forum

Go Back   Kinook Software Forum > Ultra Recall > [UR] General Discussion
Register FAQ Community Calendar Today's Posts Search

 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-10-2011, 08:19 AM
cnewtonne cnewtonne is online now
Registered User
 
Join Date: 07-27-2006
Posts: 515
How To Search Based On Order Of Words In A Sentence?

My urd db has FTS enabled. I'm trying to search based on the order of words e.g.
1) Item 1 text contains "my name is cnewtonne".
2) Item 2 text contains "cnewtonne is my name"

I want to search so that it only returns the item where "cnewtonne" APPEARS AFTER "name"

I tried the following search phrases, but none worked ...

- name NEAR cewntonne: returns both.
- name .* cnewtonne: both
- "name is cnewtonne": returns first, but I can not always tell what and how many words are between 'name' and 'cnewtonne'
- Also, for the search work NEAR, how near is near?

Thank you.
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



All times are GMT -5. The time now is 09:18 AM.


Copyright © 1999-2023 Kinook Software, Inc.