indexed full text search

for my content management system I have to realize an indexed full text search to search through articles. The sql-code must be generic, so that my cms works indepently of the used sql-server. Due to my lack of information on standard compliance of various sql-severs, I would have to implement a workaround(which would'nt be that fast).
I've already searched several times for documents on sql-standards on the internet, but I didn't find anything.

Here's the mysql-syntax to perform a full text search:

creating table with FULLTEXT-indexes:
CREATE TABLE articles (

-> id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
-> title VARCHAR(200),
-> body TEXT,
-> FULLTEXT (title,body)

     -> );

search-query (after some insert statemendt;): SELECT * FROM articles WHERE MATCH (title,body)

-> AGAINST ('test' IN BOOLEAN MODE);

Does anybody know if this (my)sql-statement is working with other db-servers respectively is standard compliant? If not - how does the standard compliant syntax look like?

thx
chris Received on Wed Sep 17 2003 - 13:25:50 CEST