使用空格作为具有剪切命令的分隔符(use space as a delimiter with cut command)

 TL;博士 
 
 不要将BETWEEN用于字符串 
 
 其中drink_name> ='G'和drink_name <'P'; 
 
 为什么？ 
 
 O有效地扩展了尾随空格以匹配列。 所以 
 
'O                  '
 
 在此之前 
 
'Oh My Gosh'
 
 所以你需要 
 
where drink_name BETWEEN 'G' and 'OZ';
 
 如果你有一种名为Ozymandias的饮料，那么这将无效。 所以： 
 
where drink_name BETWEEN 'G' and 'OZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ';
 
 但是，我们可以安全地假设没有叫P和许多空间的饮料吗？ 
 这是不可理解的。 
 
select drink_name from easy_drinks
where drink_name BETWEEN 'G' and 'P';
 
 显而易见的选择可能是仅使用LEFT比较第一个字母 
 
select drink_name from easy_drinks
where LEFT(drink_name, 1) BETWEEN 'G' and 'O';
 
 但这会阻止在drink_name上使用任何索引。 

tl;dr
 
Don't use BETWEEN for strings
 
where drink_name >= 'G' and drink_name < 'P';
 
Why?
 
The O is effectivly expanded with trailing spaces to match the column. So
 
'O                  '
 
is before
 
'Oh My Gosh'
 
So you'd need
 
where drink_name BETWEEN 'G' and 'OZ';
 
If you have a drink called Ozymandias then this won't work. So:
 
where drink_name BETWEEN 'G' and 'OZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ';
 
But, can we can safely assume that there is no drink called P and many spaces?
 This is not understandable.
 
select drink_name from easy_drinks
where drink_name BETWEEN 'G' and 'P';
 
The obvious choice might be to compare only first letters using LEFT
 
select drink_name from easy_drinks
where LEFT(drink_name, 1) BETWEEN 'G' and 'O';
 
But this will prevent used of any index on drink_name.