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.
Loading
prathyushaPosted Jun 28, 2013, 3:16 AM
prathyushaPosted Jun 28, 2013, 2:12 AM
i want to register my company details in that table
name,address, keywords
pvt, ameerpet cccc,aa,ccc cc,test search,test
xname,ameerpet aaaa,test search,testing
now i am binding the data(name,keywords) 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
Santhosh Kumar JayaramanPosted Jun 28, 2013, 1:53 AM
prathyushaPosted Jun 28, 2013, 12:24 AM
company name.
searching is possible with the name and keywords.
based on that the company details are displayed.
please help me
Santhosh Kumar JayaramanPosted Jun 27, 2013, 9:00 AM
prathyushaPosted Jun 27, 2013, 8:51 AM
gd evng
ya
it's working.
but searching is not possible with name
please help me
Santhosh Kumar JayaramanPosted Jun 27, 2013, 8:49 AM
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.
prathyushaPosted Jun 27, 2013, 8:13 AM
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 JayaramanPosted Jun 27, 2013, 8:08 AM
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'
prathyushaPosted Jun 27, 2013, 8:07 AM
by using this query
Select * from qgs where contains( keywords, ' "Automobile Service Center" ') and City = 'hyderabad' and Status='Y'
Santhosh Kumar JayaramanPosted Jun 27, 2013, 8:03 AM
What output you are getting or any error?
prathyushaPosted Jun 27, 2013, 8:00 AM
by using that query search is not possible with the name
name, keywords
aaa, cccc cc,qq,aa,search aa
bbb, cccc,text,search,aa
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 JayaramanPosted Jun 27, 2013, 7:54 AM
Select * from table where contains( keywords, "Automobile AND Automobile AND Dealers,
Automobile AND Part AND Manufacturers,Dealers,Automobile AND Dealers,Automobile AND Service AND
Center,Service AND Center,Automobile AND Spare AND Parts,Automobile AND Tools")
prathyushaPosted Jun 27, 2013, 7:41 AM
in my table i have two fields like name,keywords.
when i inserting the data to table like
name, keywords
aaa, cccc cc,qq,aa,search aa
bbb, cccc,text,search,aa
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 HussainPosted Jun 27, 2013, 7:30 AM
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 JayaramanPosted Jun 27, 2013, 7:24 AM