首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >加入mysql if else语句

问加入mysql if else语句
EN

Stack Overflow用户
提问于 2017-05-14 00:38:30
回答 1查看 37关注 0票数 0

这是一个奇怪的有条件的陈述--我不确定这是否可能。

我有一个MYSQL查询:

代码语言:javascript
复制
SELECT 
cute_news.title, cute_news.id, cute_news.avatar, cute_news.category,cute_news.date, cute_fields.YouTubeTN, cute_fields.alternate_title, cute_fields.NewsSource, cute_fields.alternate_url, cute_fields.cf_id 
FROM cute_news, cute_fields 
WHERE 
YEAR(FROM_UNIXTIME(cute_news.date)) = '2007' AND 
cute_fields.cf_id = cute_news.cf_id AND 
FIND_IN_SET ('10', cute_news.category) 
ORDER BY cute_news.date DESC

我的问题是我想:

代码语言:javascript
复制
IF ( cute_fields.cf_id = cute_news.cf_id )THEN
{  SELECT 
cute_news.title, cute_news.id, cute_news.avatar, cute_news.category,cute_news.date, cute_fields.YouTubeTN, cute_fields.alternate_title, cute_fields.NewsSource, cute_fields.alternate_url, cute_fields.cf_id 
FROM cute_news, cute_fields 
WHERE 
YEAR(FROM_UNIXTIME(cute_news.date)) = '2007' AND 
cute_fields.cf_id = cute_news.cf_id AND 
FIND_IN_SET ('10', cute_news.category) 
ORDER BY cute_news.date DESC }
ELSE {
 SELECT 
cute_news.title, cute_news.id, cute_news.avatar, cute_news.category,cute_news.date 
FROM cute_news 
WHERE 
YEAR(FROM_UNIXTIME(cute_news.date)) = '2007' AND 
FIND_IN_SET ('10', cute_news.category) 
ORDER BY cute_news.date DESC }
ORDER BY..

有最困难的时间来实际执行这个..。也许是不可能的。提前谢谢忍者!

EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2017-05-14 04:17:10

如果我清楚地理解您的需求,您需要Left Join。If将为您的NULL部件提供Else。

代码语言:javascript
复制
SELECT 
cute_news.title, cute_news.id, cute_news.avatar, cute_news.category,cute_news.date, 
cute_fields.YouTubeTN, cute_fields.alternate_title, cute_fields.NewsSource, cute_fields.alternate_url, cute_fields.cf_id 
FROM cute_news n
LEFT JOIN 
cute_fields f
ON f.cf_id = n.cf_id
WHERE 
YEAR(FROM_UNIXTIME(cute_news.date)) = '2007' AND 
FIND_IN_SET ('10', cute_news.category) 
ORDER BY cute_news.date DESC
票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/43959311

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档