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.
Im not sure if there is much of a speed difference.
Subject | Author | Views | Date |
---|---|---|---|
BINARY vs LIKE | lanerj | 2821 | Jan 5, 2002, 4:52 AM |
Re: [lanerj] BINARY vs LIKE | Paul | 2711 | Jan 5, 2002, 5:21 AM |
Re: [RedRum] BINARY vs LIKE | lanerj | 2721 | Jan 5, 2002, 7:16 PM |