RE: Query on large text field

2004-06-30 Thread Schalk
Hey there everyone

 

I have tried a couple of things but would like to know what suggestions
people on the list may have. What would be the best query term or string is
to use when searching a field, using a keyword(s), in the database that
contains a large amount of text, for example an article's content?

 

Any pointers and suggestions will be welcomed.

 

Kind Regards

Schalk Neethling

Web Developer.Designer.Programmer.President

Volume4.Development.Multimedia.Branding

emotionalize.conceptualize.visualize.realize

Tel: +27125468436

Fax: +27125468436

email:[EMAIL PROTECTED]

web: www.volume4.co.za

 

This message contains information that is considered to be sensitive or
confidential and may not be forwarded or disclosed to any other party
without the permission of the sender. If you received this message in error,
please notify me immediately so that I can correct and delete the original
email. Thank you.

 



RE: Query on large text field

2004-06-30 Thread Victor Pendleton
If the table type is MyISAM, have you tried full text indexing?

-Original Message-
From: Schalk
To: [EMAIL PROTECTED]
Sent: 6/30/04 2:31 PM
Subject: RE: Query on large text field

Hey there everyone

 

I have tried a couple of things but would like to know what suggestions
people on the list may have. What would be the best query term or string
is
to use when searching a field, using a keyword(s), in the database that
contains a large amount of text, for example an article's content?

 

Any pointers and suggestions will be welcomed.

 

Kind Regards

Schalk Neethling

Web Developer.Designer.Programmer.President

Volume4.Development.Multimedia.Branding

emotionalize.conceptualize.visualize.realize

Tel: +27125468436

Fax: +27125468436

email:[EMAIL PROTECTED]

web: www.volume4.co.za

 

This message contains information that is considered to be sensitive or
confidential and may not be forwarded or disclosed to any other party
without the permission of the sender. If you received this message in
error,
please notify me immediately so that I can correct and delete the
original
email. Thank you.

 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]