大佬教程收集整理的这篇文章主要介绍了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_datetiR_585_11845@e AND i.to_datetiR_585_11845@e 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_datetiR_585_11845@e AND i.to_datetiR_585_11845@e 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,请注明来意。