Dear All,
I am facing a problem.

The search routine works fine with "OR", but very strange in "AND".

Here is the example:
Links Title: Yahoo
URL: http://www.yahoo.com
Description: Search engine

If I use "OR" to search "Search Yahoo", it works fine, but when I use "AND" to search "Search Yahoo", it return "no matching".

Why? How to implement more logical "AND"?

That is the correct result...If you search with And, ALL the keywords you input must be found in ALL the weighted fields you've indexed. When you search with Or, ANY of the keywords you input can be found in the weighted fields you've indexed.

Hope this helps.

Regards,

Eliot Lee

Title: Taiwan Today!
URL: http://www.taiwantoday.com/
Description: Local Newspapers

If people search "Taiwan Newspaper" by using "AND", i.e. the user cannot get the newspaper only in Taiwan nor this links?

Could any people suggest some solution that user can use "AND" more logically? Because "AND" should help user get more relevant result and narrow the search result that returned by "OR".

Alex, any comments and solutions?

I believe this has been discussed before in the Links SQL Discussion Forum! Try searching there.

Did you understand my reply??? If not, how can I make it more clearer for you.

Regards,

Eliot Lee

I understand your reply.
Actually, it may not be the "question" of all you. I just post a wish that the search can fit my example.

Anyway, thanks for your help and suggestions.

For my example, it works on Links1.1 (Not SQL version), I just want to clarify that, the current situation is the fact of MySQL and has no solution to fit my examples?

Thanks,

Since you have plainly ignored my suggestion to search the
Links SQL Discussion Forum, here are some Threads
you should read:

http://www.gossamer-threads.com/...=&vc=1#Post71951

http://www.gossamer-threads.com/...=&vc=1#Post71401

http://www.gossamer-threads.com/...=&vc=1#Post71200

Regards,

Eliot Lee

What happens if you search "Yahoo Search" or "+Search +Yahoo"

http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

I get "Error: No matching links." if using "AND" with all links.

Thx for your suggestion and effort.

However, those messages cannot tell me why I use "Taiwan newspaper" can find the links in "OR" but get nothing in "AND".

I know I may be using search.cgi (may be the alias of search-ni.cgi), because I have a search-orig.cgi in cgi-bin.

Eliot Lee, really thx for your participation!
Do you think it is possible that "AND" can:

1)
Links Title: Yahoo
URL: http://www.yahoo.com
Description: Search engine

Turn Out Yahoo.com, if i use "Yahoo search" to search links with bool=AND.

2)
Title: Taiwan Today!
URL: http://www.taiwantoday.com/
Description: Local Newspapers

Turn out taiwantoday.com if I use "Taiwan Newspapers" to search by "AND".

I understand it is "Normal", but any modification can make it more "normal"?