Gossamer Forum
Home : General : Perl Programming :

BINARY vs LIKE

Quote Reply
BINARY vs LIKE
What's best to use for mysql case sensitive querys.
BINARY $words=$other_words or
LIKE $words=$other_words
Which would be faster?

Bob
http://totallyfreeads.com
Quote Reply
Re: [lanerj] BINARY vs LIKE In reply to
I'd use binary as it forces case sensitivity even if the column isn't specified as binary/blob.

Im not sure if there is much of a speed difference.

Last edited by:

RedRum: Jan 5, 2002, 5:21 AM
Quote Reply
Re: [RedRum] BINARY vs LIKE In reply to
Thanks, I am using BINARY, so i'll stick with that.

Bob
http://totallyfreeads.com