[EMAIL PROTECTED] a écrit :
Cecilia VIGNY <[EMAIL PROTECTED]> wrote:
Hi everybody,
I'm building a SQL request in order to question my SQLite database from
my php program. I would be happy if this request were compatible with a
MySQL database ;o) So what I want to know is if we can use the minus
sign as we can do with the index fulltext in MySQL. For instance, does
this request function with SQLite ? :
SELECT iden FROM cmsa c where ( wwvw LIKE "%conseil%") -( wwvw LIKE
"%agents%");
SQLite follows the SQL standard here, using "NOT LIKE".
See http://www.sqlite.org/lang_expr.html
--
D. Richard Hipp <[EMAIL PROTECTED]>
Ok so if I want to run this request :
select * from cmsa where
match(tsim,supp,nsup,even,emet,natu,mcex,indi,no,wwvw,iden,resu,comp,hist)
against ("( +test1 +test2 -(test3 test4) )")
with SQLite, which means that I want all the records which contains
(test1 AND test2) but WITHOUT (test3 OR test4), I will have to be
malignant ...! Not funny... Yuck... :o(
Ce message est protégé par les règles relatives au secret des correspondances.
Il est donc établi à destination exclusive de son destinataire. Celui-ci peut
donc contenir des informations confidentielles. La divulgation de ces
informations est à ce titre rigoureusement interdite. Si vous avez reçu ce
message par erreur, merci de le renvoyer à l'expéditeur dont l'adresse e-mail
figure ci-dessus et de détruire le message ainsi que toute pièce jointe.
This message is protected by the secrecy of correspondence rules. Therefore,
this message is intended solely for the attention of the addressee. This
message may contain privileged or confidential information, as such the
disclosure of these informations is strictly forbidden. If, by mistake, you
have received this message, please return this message to the addressser whose
e-mail address is written above and destroy this message and all files attached.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------