Question

我正在使用德国统计局:地图集,我已经获得一个结果。我愿重新排序。我要对照一个固定价值清单(伦敦”、“纽约”“东京”)检查一个特定的“核心”栏。如果城市出现在价值观清单中,我想把这一结果推向上层。如果找不到城市,我就希望把这一结果推向下院。

Answer 1

rel=“nofollow”>ORDER BYpr可能是你重新研究的。

例如,在此表格中:

mysql> select * from test;
+----+-----------+
| id | name      |
+----+-----------+
|  1 | London    |
|  2 | Paris     |
|  3 | Tokio     |
|  4 | Rome      |
|  5 | Amsterdam |
+----+-----------+

特别命令:

mysql> select * from test order by name =  London  desc, 
                                   name =  Paris   desc, 
                                   name =  Amsterdam  desc;
+----+-----------+
| id | name      |
+----+-----------+
|  1 | London    |
|  2 | Paris     |
|  5 | Amsterdam |
|  3 | Tokio     |
|  4 | Rome      |
+----+-----------+

将此转化为结果一套方法:

$schema->resultset( Test )->search(
    {},
    {order_by => {-desc => q[name in ( London ,  New York ,  Tokyo )] }}
);

Answer 2

类似:

#!/usr/bin/env perl
use strict;
use warnings;
my $what = shift or die;
my @ary  = qw(alpha beta gamma);
unshift(@ary,$what) unless ( grep(/$what/,@ary) );
print "@ary
";
1;

如下:

./myscript omega

友情链接