Standard SQL for comparing strings is LIKE '=' in lieu of 'LIKE' is a MySQL extension to SQL, therefore non-standard. Ignatius _________________________ ----- Original Message ----- From: <Tristan.Pretty@xxxxxxxxxxxxxxxx> To: <php-db@xxxxxxxxxxxxx> Sent: Friday, January 16, 2004 15:39 Subject: MySQL general Question... > What's teh diffence between 'LIKE' & '=' > EG: SELECT & FROM my_table WHERE 'email' LIKE '123@xxxxxxxxxxx' > > 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
