[EMAIL PROTECTED] wrote:
What's teh diffence between 'LIKE' & '='
EG: SELECT & FROM my_table WHERE 'email' LIKE '[EMAIL PROTECTED]'
= is an equality (case insensitive). LIKE allows you to use the %
character as a wildcard (will match any amount of characters) and the _
character as a wildcard to
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, 20
with the like command you could made search such as :
SELECT & FROM my_table WHERE 'email' LIKE '[EMAIL PROTECTED]'
and you could have several answer.
= is for scrict equality
[EMAIL PROTECTED] wrote:
What's teh diffence between 'LIKE' & '='
EG: SELECT & FROM my_table WHERE 'email' LIKE '[
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...
