sql query

Question

hi Select * from table where freetext( keywords Automobile Automobile Dealers Automobile Part ManufacturersDealersAutomobile DealersAutomobile Service CenterService CenterAutomobile Spare PartsAutomobile 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 DealersAutomobile Part ManufacturersDealersAutomobile Dealers. please help me. it's very important to me.

prathyusha · Answer

hi it's very important to me. please help me

prathyusha · Answer

hi i want to register my company details in that table nameaddress keywords pvt ameerpet ccccaaccc cctest searchtest xnameameerpet aaaatest searchtesting now i am binding the data(namekeywords) to textbox using autocompleteextender i am attaching file if i select name then searching is possible with name if i select keyword like test (only single word) then display the first comapany details only please help me

prathyusha · Answer

hi santhosh company name. searching is possible with the name and keywords. based on that the company details are displayed. please help me

Santhosh Kumar Jayaraman · Answer

what do you mean by name?

prathyusha · Answer

hi gd evng ya it's working. but searching is not possible with name please help me

Santhosh Kumar Jayaraman · Answer

have you tried this? Select * from qgs where contains( keywords ' Automobile AND Service AND Center ') and City = 'hyderabad' and Status='Y' It wont consider And it will check for fields which has all three keywords automobile service and center. Run and let me know.

prathyusha · Answer

hi in my database keyword field is like Automobile Service Center only no need to add and. but i need to search with name also it's not possible with contains method please help me

Santhosh Kumar Jayaraman · Answer

No. Not this. In my query  i added And in between each keyword. Like the below bolded one Select * from qgs where contains( keywords ' Automobile AND Service AND Center ') and City = 'hyderabad' and Status='Y'

prathyusha · Answer

no error by using this query Select * from qgs where contains( keywords ' Automobile Service Center ') and City = 'hyderabad' and Status='Y'

Santhosh Kumar Jayaraman · Answer

not possible with name? What output you are getting or any error?

prathyusha · Answer

hi santhosh by using that query search is not possible with the name name keywords aaa cccc ccqqaasearch aa bbb cccctextsearchaa in code file i am passing only one word like cccc cc not total based on that only search the data and based on name also search the data if i pass the name then search the data based on name please help me

Santhosh Kumar Jayaraman · Answer

try this Select * from table where contains( keywords Automobile AND Automobile AND Dealers Automobile AND Part AND ManufacturersDealersAutomobile AND DealersAutomobile AND Service AND CenterService AND CenterAutomobile AND Spare AND PartsAutomobile AND Tools)

prathyusha · Answer

hi santhosh in my table i have two fields like namekeywords. when i inserting the data to table like name keywords aaa cccc ccqqaasearch aa bbb cccctextsearchaa now i have to search the data using that table. Select * from table where freetext( keywords  cccc cc) then the query displayed 2 names.by using freetext it takes cccc(firstword only not total word) but now ineed to display one name based on cccc cc how can it's possible. please help me it's important to me

Iftikar Hussain · Answer

Hi You can do this like below Select * from table where keywords like '% Automobile %' and City = hyderabad and Status='Y' Let me know if you need more information Regards Iftikar Remember to click Mark as Answer on the post if it helps you.

Santhosh Kumar Jayaraman · Answer

Its not clear. Can you explain more?

Santhosh Kumar Jayaraman · Answer

can you give some example?