16
Reply

sql query

prathyusha

prathyusha

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

Upload Source Code  Select only zip and rar file.
Answers (16)