hi,
Select * from table where freetext( keywords, "Automobile Automobile Dealers,
Automobile Part Manufacturers,Dealers,Automobile Dealers,Automobile Service
Center,Service Center,Automobile Spare Parts,Automobile Tools")
and City = "hyderabad" and Status='Y'
when i use this query the data displayed based on this word like Automobile(it takes only
first word) .but i need to Select * from table where keywords= "Automobile Automobile
Dealers"
but keywords like Automobile Automobile Dealers,Automobile Part Manufacturers,Dealers,Automobile Dealers.
please help me. it's very important to me.