脚本宝典收集整理的这篇文章主要介绍了php – Mysql在case语句中使用DESC，脚本宝典觉得挺不错的，现在分享给大家，也给大家做个参考。
ORDER BY i.id DESC
SELECT
sql_CALC_FOUND_ROWS i.*,c.tITle AS category_name,u.name,u.family,i.thumb_image,CONCAT( u.name,' ',u.family ) AS author,tumbnail_image_width,tumbnail_image_height
From contents i
JOIN categories c ON c.id = i.category
JOIN users u ON u.id = i.posted_by
JOIN settings s ON s.portal = i.portal
WHERE
i.portal = '{$portal_id}'
AND CASE WHEN post_tyPE = 4
THEN date(Now()) BETWEEN i.from_dateTime AND i.to_dateTime
ELSE post_type = 1
END
AND i.t_status = 1
ORDER BY
CASE (SELECT sortable FROM settings)
WHEN 1 THEN i.id
WHEN 2 THEN i.date_time
WHEN 3 THEN i.order_display
END
LIMIT {$portalSettings['display_post_count']};";
SELECT
sql_CALC_FOUND_ROWS i.*,tumbnail_image_height,CASE (s.sortable)
WHEN 1 THEN 100000000 - i.id
WHEN 2 THEN i.date_time
WHEN 3 THEN i.order_display
END AS SortField
FROM contents i
JOIN categories c ON c.id = i.category
JOIN users u ON u.id = i.posted_by
JOIN settings s ON s.portal = i.portal
WHERE
i.portal = '{$portal_id}'
AND CASE WHEN post_type = 4
THEN date(Now()) BETWEEN i.from_dateTime AND i.to_dateTime
ELSE post_type = 1
END
AND i.t_status = 1
ORDER BY SortField
LIMIT {$portalSettings['display_post_count']};";
请注意,您可能必须将字段强制转换为数据类型才能执行此操作.
以上是脚本宝典为你收集整理的php – Mysql在case语句中使用DESC全部内容，希望文章能够帮你解决php – Mysql在case语句中使用DESC所遇到的问题。
本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ：384754419，请注明来意。