What I do is this :
select * from table where hugetextfield like '%blegh%'
This would give you all records containing the the text blegh
Trausti
On Nov 22, 2006, at 9: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?
--
Cheers,
Dr Gerard Hammond
MacSOS Solutions
_______________________________________________
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>
_______________________________________________
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>
