[V4MD] Index by Words (newbie question)

[Daniel Crowder]

nm. I was over-thinking that last question!

SELECT * FROM product_attributes WHERE text = 'metal' and text = 'cast'

Doing that on a field that is indexed by words returns the desired 
result. No need for anything else!



On Oct 3, 2004, at 6:05 PM, Daniel Crowder wrote:

> Thanks!
>
> If I wanted to search a complete word and not a partial word is there 
> a more streamlined way of doing that?
>
> On Oct 3, 2004, at 5:53 PM, Ruslan Zasukhin wrote:
>
>> On 10/4/04 12:48 AM, "Daniel Crowder" <daniel at monumental-i.com> wrote:
>>
>> Hi Daniel,
>>
>>> I'm looking for ways to speed-up a product search.
>>>
>>> I currently am using LIKE to check to see if certain key-words exist 
>>> in
>>> a field called TEXT. Reading over the documentation it says that 
>>> using
>>> LIKE in a query does not take advantage of a field's index. I am now
>>> confused as to how to take advantage of the INDEX BY WORDS feature. 
>>> How
>>> do I perform the fastest query of a text field that is using INDEX BY
>>> WORDS without using LIKE?
>>
>> You should do query of kind
>>
>>     WHERE left( textFld, 3 ) = 'abc'
>>
>> This will use index
>>
>>
>> -- 
>> Best regards,
>> Ruslan Zasukhin      [ I feel the need...the need for speed ]
>> -------------------------------------------------------------
>> e-mail: ruslan at paradigmasoft.com
>> web: http://www.paradigmasoft.com
>>
>> To subscribe to the Valentina mail list go to:
>> http://lists.macserve.net/mailman/listinfo/valentina
>> -------------------------------------------------------------
>>
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>>
>>
> _______________________________
> Daniel Crowder
> Partner
>
> Monumental
> Natural Interactive Solutions
>
> 828 Ralph McGill Blvd. W-2
> Atlanta, GA 30306
>
> AIM: danielmonumental
> Phone: 404.223.0303
> Fax: 404.223.0309
> monumental-i.com
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
>
_______________________________
Daniel Crowder
Partner

Monumental
Natural Interactive Solutions

828 Ralph McGill Blvd. W-2
Atlanta, GA 30306

AIM: danielmonumental
Phone: 404.223.0303
Fax: 404.223.0309
monumental-i.com