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 »

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: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: How to search correct

Post by Thorsten »

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 »

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: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: How to search correct

Post by Thorsten »

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 »

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