MySQL capabilities

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? Can I tell MySQL to only returns me a subset of results, I mean only 10 results? How fast is MySQL? 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. Best Regards. ------------------------------------------------------------- ebnoud.com, El Boletín No Oficial de Usuarios de Delphi http://www.ebnoud.com VCLCrawler.com, tu motor de búsqueda de componentes VCL http://www.vclcrawler.com