[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 match a single character.


In your example, LIKE is being used ineffeciently.

(Have I been living in a box?)

Yes? ;)


--
---John Holmes...

Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/

php|architect: The Magazine for PHP Professionals – www.phparch.com

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



Reply via email to