very technical ( sql writing)
Posted on 2003-03-26
I have two tables as below:
1- articleAid,description,title,abstract,location); AID=P.K
2-keywords( AID,keyword) ; aid+keyword=p.k , aid=f.k
I want to search for special keywords in article for special keywords that users enter in entry place( edit.text).
We have two branch of keywords
1- usual keyword ( that separated with spaces)
2- included keyword(that at frist of these keywords come ‘+’ sign as google page )
suppose you have two arrays for invidual keywords.
I don’t need any coding for seprating of keywords.
online +Delphi demo +example
mean of this example:
search for articles that should include (Delphi and example together) keywords and (online,demo one or twice in articles that have DELPHI EXAMPLE ) .
the mean of my sql request as below:
if have all(included keywords) then
if have(space keyword) then
search for usual keywords in result of (included keywordsßpayattention)
return the result of search for(included keywordsßpayattention )
search for usual keywords in articlesß pay attention
can anyone write sql statement for this issue?
Thanks in advance
God bless you