This is perhaps more suited on mysql mailing list, but anyway...
On 4/29/2001 06:18 PM, José León Serna wrote:
> Hello:
> Since no one asks my question about access to InterBase from PHP, I'm
> considering MySQL ;-)
> I would like to know more about the reliability and functionality from PHP
> users, I'm going to make searchs on a database with big text in Blob fields.
> Right now, in my web (it's made in Delphi) I'm using the Rubicon product to
> make searchs on a database and it works really fast, my questions are:
> Can I use MySQL to search for a substring in a Memo Field?
yes. mysql >3.23.25 even supports full text searching. search
for FULLTEXT in mysql manual.
> Can I tell MySQL to only returns me a subset of results, I mean only 10
> results?
yes, this is one of the conveniences of MySQL, thanks to its
LIMIT clause.
> How fast is MySQL?
relatively very fast, since it supports only a subset of
SQL standards.
> I have a database with 11000 records (not too many) but
> with a big Memo Field and I want to search for words to show the results
> that match the users query.
use FULLTEXT indexing. before MySQL has this, I wrote KwIndex.
You might find it useful:
http://steven.haryan.to/php/KwIndex.html
There's also various full text indexing package you can use:
htdig, glimpse, etc. Most of them work best with content in
filesystem though.
Steve
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
