mysql根据LEAST值返回正确的链接 - mysql returning correct link depending on the LEAST value

mysql returning correct link depending on the LEAST value

本文关键字：链接返回根据 LEAST mysql | 更新日期: 2023-12-21

好吧，这有点棘手，但基本上在我的SQL语句中，我比较每行字段之间的价格以获得返回的最低值，现在的问题是每个值都有一个链接。

是否有一种方法可以根据SQL语句中的最低值返回正确的链接？

下面是我的SQL语句。

SELECT 
   title, 
   my_value, 
   my_ink,
   LEAST(site_a_value, site_b_value, site_c_value) AS lowest_value, 
   site_a_link,
   site_b_link,
   site_c_link
   FROM STOCK

例如，如果site_b的值最低，我只希望返回site_b_link。

尝试

SELECT     title,
            my_value,
            my_ink,
            LEAST(site_a_value, site_b_value, site_c_value) AS lowest_value,     
            case LEAST(site_a_value, site_b_value, site_c_value)
            when site_a_value then site_a_link
            when site_b_value then site_b_link
            when site_c_value then site_c_link end AS lowest_value_link,
FROM STOCK

试试这个：

SELECT 
  title, my_value, my_ink,
  LEAST(site_a_value, site_b_value, site_c_value) AS lowest_value, 
  (
  CASE site_a_value = LEAST(site_a_value, site_b_value, site_c_value)
    THEN site_a_link
  ELSE CASE site_b_value = LEAST(site_a_value, site_b_value, site_c_value)
    THEN site_b_link
  ELSE
    site_c_link
  ) AS site_link
FROM STOCK