How to search correct

In this board you can talk about general questions about phpMyFAQ

Moderator: Thorsten

Post Reply
DWChris
Posts: 1
Joined: Thu Jun 07, 2012 2:37 pm

How to search correct

Post by DWChris » Thu Jun 07, 2012 2:45 pm

Hi @ all,

I have a search problem and i couldn't find a hit or a solution.

If I search in phpmyfaq for "electronic signature" i got results for "electronic" and for "result".
In which way I have to search that the both word will combined. In other words...I need a logical AND between the words.
I tried the follwing combinations

"electronic signature"
'electronic signature'
(electronic signature)
electronic+signature
electronic +signature

Btw. FAQ Version 2.7.5 and we are using MSSQl in the background

greetings
Chris

Thorsten
Posts: 14754
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: How to search correct

Post by Thorsten » Sat Jun 09, 2012 11:40 am

Hi,

the current implemented search with MS SQL is just a simple LIKE search in SQL. We currently have no logical AND implemented with this database. Sorry.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

JochenS
Posts: 121
Joined: Wed Feb 16, 2011 3:51 pm
Location: Schönaich
Contact:

Re: How to search correct

Post by JochenS » Wed Jun 27, 2012 9:57 am

According to the MySQL search http://dev.mysql.com/doc/refman/5.1/en/ ... olean.html you need to search for:

+electronic +signature
Our public FAQ is proudly powered by phpMyFAQ: http://vhtfaq.ge51.honeywell.de/

Thorsten
Posts: 14754
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: How to search correct

Post by Thorsten » Wed Jun 27, 2012 10:04 am

Hi Jochen,

he's using MS SQL ;-)

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

JochenS
Posts: 121
Joined: Wed Feb 16, 2011 3:51 pm
Location: Schönaich
Contact:

Re: How to search correct

Post by JochenS » Wed Jun 27, 2012 1:56 pm

hgrr.. I read just M*SQL
Our public FAQ is proudly powered by phpMyFAQ: http://vhtfaq.ge51.honeywell.de/

Post Reply