查询字符串和时间旅行 [英] queries strings and time travel

问题描述

我有一个使用ORDER BY的查询

我希望它通过在查询结束时的一些子查询后生成的字符串进行排序。

有没有一个很好的技巧来做到这一点，还是我需要找到一种方法来获取查询之前的字符串？

I have a query that uses ORDER BY
I would like it to order by a string that is made after some sub queries at the end of the query.
Is there a nice trick to do this or do I need to find a way to get the string made before the query?

推荐答案

我有一个使用ORDER BY的查询

我希望它通过在查询结束时的一些子查询之后生成的字符串来订购。

有一个很好的技巧可以做到这一点，还是我需要找到一种方法来获取查询之前的字符串？

I have a query that uses ORDER BY
I would like it to order by a string that is made after some sub queries at the end of the query.
Is there a nice trick to do this or do I need to find a way to get the string made before the query?

一招......？你对子查询的查询是什么样的？

A trick...? What does your query with the sub query look like?

感谢volectricity，这是一个减少，我已经删除了一些其他子'和html

[PHP]<？php

Thanks volectricity, this is a cutdown, I''ve removed some other sub''s and html

[PHP]<?php

query1 =（" SELECT DISTINCT（teamname），conference_team.id AS teamid

来自conference_team

INNER JOIN conference_results

ON conference_results.hometeam = conference_team.id

赛季

LIKE' '2005-06''

ORDER BY''

query1 = ("SELECT DISTINCT(teamname),conference_team.id AS teamid
FROM conference_team
INNER JOIN conference_results
ON conference_results.hometeam = conference_team.id
WHERE season
LIKE ''2005-06''
ORDER BY ''

这篇关于查询字符串和时间旅行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！