On Nov 22, 2006, at 1:42 PM, Dr Gerard Hammond wrote:

Hi,

When I do a SQLselect and search for a fragment of a string in a text field, will the SQLselect actually search the entire contents of my TEXT and BLOB columns.

ie is full-text search builtin?

you can get it to but it does not seem to be indexed in any way that makes it run faster

if you do

        like '%something%'

on a big blob or text it can still take a while

I've done this
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>

Reply via email to