var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Logical operators in BETWEEN clause
Is this kosher?
SELECT item_name FROM menu_item WHERE item_name BETWEEN 'A|a' AND 'M|m';
Or Will MySQL do a case insensitive query?
I know MySQL doesn't concern itself with case sensitivity with column names, but what about in the WHERE & BETWEEN clause?
I ask because I get the same ( correct ) results whether I run the query
with uppercase or lower case and also when using the logical operators.
I doubt that it is case sensitive although i don't know for sure
You are correct. The searches are case-insensitive. However, you can use functions to help you determine the case which may help you.
See the following link:
Thanks all. Case insensitvity is what I'm after here, and my questions have been answered.
Rnealjr, thanks for the link