Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- string comparisons with case
October 4, 2006, 5:17 pm
rate this thread
Re: string comparisons with case
By default, MySQL searches are not case sensitive . This means that if
you search with col_name LIKE 's%', you get all column values that
start with S or s.
If you want a column always to be treated in case-sensitive fashion,
declare it with a case sensitive or binary collation.
- » Question 9 is the only one correct rest keep coming up syntax errors.help
- — Next thread in » MySQL Database Forum
- » All Records From Table A - All Records From Table B - Join Alike Records
- — Previous thread in » MySQL Database Forum
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum
- » ssh on command line: force using a group size (prime size) of 1024 (and no...
- — The site's Newest Thread. Posted in » Secure Shell Forum