Re: MySQL general Question...

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@risk.sungard.com> To: <php-db@lists.php.net> 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 '123@hotmail.com' > > 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. > *********************************************************************** > >