SELECT bunch_of_columns FROM bunch_of_tables
WHERE MATCH (memos.note_text)
AGAINST ('frog' IN NATURAL LANGUAGE MODE);
You may want to consider implementing lucene for search engine capability
http://lucene.apache.org/java/docs/
?
Martin
______________________________________________
Verzicht und Vertraulichkeitanmerkung / Disclaimer and confidentiality note
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung
oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem
Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung.
Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung
fuer den Inhalt uebernehmen.
This message is confidential and may be privileged. If you are not the intended
recipient, we kindly ask you to please inform the sender. Any unauthorised
dissemination or copying hereof is prohibited. This message serves for
information purposes only and shall not have any legally binding effect. Given
that e-mails can easily be subject to manipulation, we can not accept any
liability for the content provided.
> From: jschwa...@the-infoshop.com
> To: wagnerbian...@yahoo.com.br
> CC: mysql@lists.mysql.com
> Subject: RE: Error -1
> Date: Mon, 23 Mar 2009 10:26:36 -0400
>
>
>
> From: Wagner Bianchi [mailto:wagnerbian...@yahoo.com.br]
> Sent: Monday, March 23, 2009 7:57 AM
> To: Jerry Schwartz
> Subject: Res: Error -1
>
> Hi friend,
>
> You can use this, but, the -1 Error you got on the situation in you use
> InnoDB
> and it's crash.
>
> [JS] I'm not using InnoDB for this table, it needs a full-text index so it
> has
> to be MyISAM:
>
> Create Table: CREATE TABLE `memos` (
> `note_id` int(11) NOT NULL AUTO_INCREMENT,
> `customer_id` int(11) DEFAULT NULL,
> `note_timestamp` datetime DEFAULT NULL,
> `note_text` text,
> PRIMARY KEY (`note_id`),
> KEY `customer_id` (`customer_id`),
> FULLTEXT KEY `note_text` (`note_text`)
> ) ENGINE=MyISAM AUTO_INCREMENT=102353 DEFAULT CHARSET=utf8
>
>
> Curious, somebody know more about this question?
>
> Wagner Bianchi
> Diretor de Tecnologia - INFODBA C&T
> wagnerbian...@infodba.com.br - (31) 3272 - 0226 / 9114 - 7695
>
>
>
> ________________________________________
> De: Jerry Schwartz <jschwa...@the-infoshop.com>
> Para: MySql <mysql@lists.mysql.com>
> Enviadas: Sábado, 21 de Março de 2009 22:56:30
> Assunto: Error -1
>
> I'm running 5.1.31-community on WinXP.
>
> I'm getting
>
> ERROR 1030 (HY000): Got error -1 from storage engine
>
> from the following query:
>
>
> SELECT SQL_CALC_FOUND_ROWS customers.*, account.account_name,
> account.real_name AS `Sales Rep`, stage.stage_name, memos.note_text AS
> m_note_text
> FROM customers INNER JOIN account ON account.account_id =
> customers.account_id
> INNER JOIN stage ON customers.stage_id = stage.stage_id
> LEFT JOIN memos ON customers.customer_id = memos.customer_id AND
> (memos.note_id = (SELECT note_id FROM memos WHERE
> memos.customer_id=customers.customer_id
>
> AND (MATCH(memos.note_text) AGAINST ("frog"))
>
> ORDER BY note_timestamp DESC LIMIT 1) OR memos.note_id IS NULL) LIMIT 0,25;
>
> If I take out the MATCH term, the query works just fine.
>
> SELECT SQL_CALC_FOUND_ROWS customers.*, account.account_name,
> account.real_name AS `Sales Rep`, stage.stage_name, memos.note_text AS
> m_note_text
> FROM customers INNER JOIN account ON account.account_id =
> customers.account_id
> INNER JOIN stage ON customers.stage_id = stage.stage_id
> LEFT JOIN memos ON customers.customer_id = memos.customer_id AND
> (memos.note_id = (SELECT note_id FROM memos WHERE
> memos.customer_id=customers.customer_id
> ORDER BY note_timestamp DESC LIMIT 1) OR memos.note_id IS NULL) LIMIT 0,25;
>
> The error -1 isn't very helpful, does anyone have a clue? Perhaps I can't
> use MATCH in a JOIN condition?
>
>
> Regards,
>
> Jerry Schwartz
> The Infoshop by Global Information Incorporated
> 195 Farmington Ave.
> Farmington, CT 06032
>
> 860.674.8796 / FAX: 860.674.8341
>
> www.the-infoshop.com
> www.giiexpress.com
> www.etudes-marche.com
>
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=wagnerbian...@yahoo.com.br
>
> ________________________________________
> Veja quais são os assuntos do momento no Yahoo! + Buscados: Top 10 -
> Celebridades - Música - Esportes
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com
>
_________________________________________________________________
Get quick access to your favorite MSN content with Internet Explorer 8.
http://ie8.msn.com/microsoft/internet-explorer-8/en-us/ie8.aspx?ocid=B037MSN55C0701A
