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]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------