Re: exclude some results with mysql
| From: | Negrea Mihai | Date: | Mon, 03 Feb 2003 11:35:23 +0000 |
| Subject: | Re: exclude some results with mysql | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-134102@lists.php.net to get a copy of this message | ||
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
use "like"
SELECT name FROM users WHERE email not like '%@domaine.com'
On Monday 03 February 2003 13:05, Clement Noterdaem wrote:
> what's wrong in this SQL line??
>
> "SELECT name FROM users WHERE email<>'%@domaine.com' (...)"
>
> I want every names, except people with an email "@domaine.com"...
- --
Negrea Mihai
http://www.negrea.net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
iD4DBQE+PlP88hhhNOp8KlQRAnZJAJdj/txQ/hnxlDTYA7dLW2VcmloCAJ9Px8fN
rAC32oNdKnyYx/mcSGrxpg==
=LkxR
-----END PGP SIGNATURE-----