Laravel Raw查询不识别别名

发布于 2025-01-20 21:03:29 字数 732 浏览 0 评论 0原文

我想要什么：我有一个模型，想要触发原始查询。我为此使用 selectRaw() 。在 selectRaw 中，我传递了带有 as 作为别名的选择字符串。当我触发查询时，我得到了所需的列表，包括别名。

问题：但现在我想过滤别名。为此，我使用Raw。我也想改变纯粹的顺序。为此，我使用 whereRaw() 和 orderRaw()。不幸的是，我随后收到一条错误消息：

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Distance' in...

我的查询：

Model::selectRaw('col1,col2,col3,
            (6368 * SQRT(2*(1-cos(RADIANS(lat))))) AS Distance')
            ->whereRaw('Distance <= 3')
            ->orderByRaw('Distance')
            ->take(20)
            ->get();

问题： 为什么会这样无法识别别名距离？

原文

What i want: I have a model and want to fire a raw query. I use a selectRaw() for this. Inside the selectRaw I pass the select string with an as as alias. When I fire the query I get the desired list including the alias.

Problem: But now I want to filter the alias. For this I use where Raw. I would also like to change the pure order. For this I use whereRaw() and orderRaw(). Unfortunately, I then get an error message:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Distance' in...

My query:

Model::selectRaw('col1,col2,col3,
            (6368 * SQRT(2*(1-cos(RADIANS(lat))))) AS Distance')
            ->whereRaw('Distance <= 3')
            ->orderByRaw('Distance')
            ->take(20)
            ->get();

Question: Why does it not recognise the alias Distance?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

浪漫人生路 2025-01-27 21:03:29

有关别名的信息，请参阅 Mysql 文档。

它只是说，您不能在 where 子句中使用别名，因为它在运行 where 时不会被评估。

标准 SQL 不允许在 WHERE 子句中引用列别名。施加此限制是因为当计算 WHERE 子句时，列值可能尚未确定。例如，以下查询是非法的：

您可以使用 HAVING 或 eloquent having 函数代替。

Model::selectRaw('
  col1,
  col2,
  col3, 
  (6368 * SQRT(2*(1-cos(RADIANS(lat))))) AS Distance
')
->having('Distance', '<=' '3')
->orderByRaw('Distance')
->take(20)
->get();

它应该有效。

See Mysql Doc about aliases.

It simply says, that you can't use alias in where clauses, simply because it is not evaluated when where runs.

Standard SQL disallows references to column aliases in a WHERE clause. This restriction is imposed because when the WHERE clause is evaluated, the column value may not yet have been determined. For example, the following query is illegal:

Instead you can use HAVING or eloquent having function.

Model::selectRaw('
  col1,
  col2,
  col3, 
  (6368 * SQRT(2*(1-cos(RADIANS(lat))))) AS Distance
')
->having('Distance', '<=' '3')
->orderByRaw('Distance')
->take(20)
->get();

It should work.

回复收藏 0 原文

~没有更多了~