Re: MySQL general Question...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Tristan.Pretty@xxxxxxxxxxxxxxxx wrote:

What's teh diffence between 'LIKE' & '='
EG: SELECT & FROM my_table WHERE 'email' LIKE '123@xxxxxxxxxxx'

= 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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux