prathyusha

prathyusha

  • NA
  • 180
  • 74.9k

sql query

Jun 27 2013 6:56 AM
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.

Answers (16)