Standard SQL for comparing strings is LIKE
'=' in lieu of 'LIKE' is a MySQL extension to SQL, therefore non-standard.

Ignatius
_________________________
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 16, 2004 15:39
Subject: [PHP-DB] MySQL general Question...


> What's teh diffence between 'LIKE' & '='
> EG: SELECT & FROM my_table WHERE 'email' LIKE '[EMAIL PROTECTED]'
>
> I've just purchased an E-mail marketing piece of software, and was peakign
> in the code...
> Found that... Never seen it before (Have I been living in a box?)
>
> Cheers,
> Tris...
>
> *********************************************************************
> The information contained in this e-mail message is intended only for
> the personal and confidential use of the recipient(s) named above.
> If the reader of this message is not the intended recipient or an agent
> responsible for delivering it to the intended recipient, you are hereby
> notified that you have received this document in error and that any
> review, dissemination, distribution, or copying of this message is
> strictly prohibited. If you have received this communication in error,
> please notify us immediately by e-mail, and delete the original message.
> ***********************************************************************
>
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to