April 1st, 2013, 08:37 PM
WHERE column BETWEEN 'd' AND 'f'
Does this mean find all items where their name startes with d, e or f?
If so is it really the best solution?
WHERE name BETWEEN 'd' AND 'f'
April 1st, 2013, 08:48 PM
No, it means to find items where the name sorts between the strings "d" and "f". That includes "e", "d" and "f" (because BETWEEN is inclusive), "demographic", and "elliptical", but it does not include "fluoride" (because it sorts after "f").
Additionally, if you're using a case-sensitive collation (which you can tell by checking if the collation is binary or its name ends in "cs") it will not include "Demographic".
WHERE name >= 'd' AND name < 'g'