Re: MySQL capabilities

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