At 22:41 10/07/2001 +0200, you wrote:
> > after reading the excellent docs, I was just a little confused as to the
> > actual length of the TEXT datatypes. Are they really as long as you like?
>
>See http://www.mysql.com/doc/n/o/node_180.html
>
> > And does anyone have any tips for indexing (searching) them?
>
>What do you mean? Searching is something different than indexing.
>You may be interested in the FULLTEXT clause. See
>http://www.mysql.com/doc/F/u/Fulltext_Search.html and follwing
>for details.
Are those commands "Standard SQL"?
CREATE TABLE articles (
-> id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
-> title VARCHAR(200),
-> body TEXT,
-> FULLTEXT (title,body)
-> );
- SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database');
Where could I found a list of the SQL standard function ?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
