|
|
Posted by masri999 on 10/04/06 11:15
FROM BOL,
column_list
Indicates that several columns, separated by a comma, can be specified.
column_list must be enclosed in parentheses. Unless language_term is
specified, the language of all columns of column_list must be the same.
*
Specifies that all columns in the table registered for full-text
searching should be used to search for the given contains search
condition. The columns in the CONTAINS clause must come from a single
table. If more than one table is in the FROM clause, * must be
qualified by the table name. Unless language_term is specified, the
language of all columns of the table must be the same.
We can use * for all full-text Columns or Column List
M A Srinivas
djamilabouzid@gmail.com wrote:
> Hi,
>
> I have a question about MS SQL Server 2005:
>
> I have a table in the database that contains 70 fields. I must perform
> full-text search in about 60 fields. I use for that the full-text
> searching "CONTAINS" like that:
>
> SELECT ProductName
> FROM Products
> WHERE CONTAINS(ProductName, '"laugh*" NEAR lager')
>
> My question is: for the 60 fields in the table that I want to do
> full-text search for the same expression, may I write a query like
> that:
>
> Select f1, ..., fm
> From table
> Where CONTAINS(f1, expr) and CONTAINS(f2, exp) ... and
> CONTAINS(f60,expr)
>
> Or there is a more compact way to write this query.
>
> Thank you very much for your answer,
>
> Regard,
>
> Djamila.
Navigation:
[Reply to this message]
|