来自「JAVA下的SQL_System的建立」· 代码 · 共 42 行

CONTAINS
    ( { column | * } , '< contains_search_condition >' 
    ) 

< contains_search_condition > ::=
        { < simple_term >
        | < prefix_term >
        | < generation_term >
        | < proximity_term >
        | < weighted_term >
        } 
        | { ( < contains_search_condition > )
        { AND | AND NOT | OR } < contains_search_condition > [ ...n ] 
        } 

< simple_term > ::=
    word | " phrase "

< prefix term> ::=
    { "word * " | "phrase * " }

< generation_term > ::=
    FORMSOF ( INFLECTIONAL , < simple_term > [ ,...n ] ) 

< proximity_term > ::=
    { < simple_term > | < prefix_term > }
    { { NEAR | ~ } { < simple_term > | < prefix_term > } } [ ...n ]

< weighted_term > ::=
    ISABOUT
        ( { { 
                <simple_term>
                | < prefix_term >
                | < generation_term >
                | < proximity_term >
                } 
            [ WEIGHT ( weight_value ) ]
            } [ ,...n ] 
        ) 
FREETEXT语法：
FREETEXT ( { column | * } , 'freetext_string' )