<xmp id="gc8um"><menu id="gc8um"></menu>
<tr id="gc8um"></tr>
<tr id="gc8um"></tr>
<object id="gc8um"><center id="gc8um"></center></object>
<rt id="gc8um"><small id="gc8um"></small></rt>
<tr id="gc8um"></tr>
<acronym id="gc8um"><center id="gc8um"></center></acronym>
<samp id="gc8um"></samp>
<option id="gc8um"></option>
<tt id="gc8um"><div id="gc8um"></div></tt>
<acronym id="gc8um"><optgroup id="gc8um"></optgroup></acronym>
<samp id="gc8um"></samp>
<rt id="gc8um"></rt>
<rt id="gc8um"></rt>
<rt id="gc8um"><optgroup id="gc8um"></optgroup></rt>
<tr id="gc8um"></tr>
<acronym id="gc8um"><optgroup id="gc8um"></optgroup></acronym>
<acronym id="gc8um"><small id="gc8um"></small></acronym>
<sup id="gc8um"><small id="gc8um"></small></sup>
<acronym id="gc8um"><optgroup id="gc8um"></optgroup></acronym>
<rt id="gc8um"><optgroup id="gc8um"></optgroup></rt>
<optgroup id="gc8um"><menu id="gc8um"></menu></optgroup>
<tr id="gc8um"></tr>
<rt id="gc8um"><small id="gc8um"></small></rt>
<menu id="gc8um"><noscript id="gc8um"></noscript></menu>
<option id="gc8um"></option>
<rt id="gc8um"></rt>
<acronym id="gc8um"><small id="gc8um"></small></acronym>
<rt id="gc8um"><optgroup id="gc8um"></optgroup></rt><acronym id="gc8um"><small id="gc8um"></small></acronym><rt id="gc8um"></rt>
<rt id="gc8um"><optgroup id="gc8um"></optgroup></rt><acronym id="gc8um"><small id="gc8um"></small></acronym>
<acronym id="gc8um"><small id="gc8um"></small></acronym>
<object id="gc8um"><small id="gc8um"></small></object>
<tr id="gc8um"></tr>
<rt id="gc8um"><small id="gc8um"></small></rt>
<tr id="gc8um"><optgroup id="gc8um"></optgroup></tr>
<samp id="gc8um"></samp>
<acronym id="gc8um"><small id="gc8um"></small></acronym>

如何在PostgreSql數據中SELECT的時候A字段如果內容空就返回B字段的內容?

0
PostgreSQL 數據庫 17053 次瀏覽

   content表有一個body字段和clean_body字段,單獨獲取body很容易用,select body from content就可以了,最近業務需要擴展了一個clean_body字段,用來存放body清洗后的數據。現在業務邏輯就是在clean_body中內容為空時,自動到body中去獲取數據。

   如果直接將兩個字段的內容都讀出(select body,clean_body from content)然后在代碼中自己判斷也是可以的,這樣做總覺得怪怪的,如果在數據庫一層就可以做到的話是最完美的!

請盡量讓自己的答案能夠對別人有幫助

9個答案

默認排序按投票排序
0

Students usually look for University term paper writing service when they cannot tackle their assigned project on their own. They prefer taking help with University case study writing service for subjects that are really tough and cannot be managed by them. That University homework writing service can be in the form of their elders or classmates or previous project samples. But there is certainly a huge difference between a professional GlobalResearchService and an amateur, a sample paper and a fair project submission.

0

我對你在文章中提供的信息印象非常深刻。 我必須說你的整個故事都非常不知所措。 現在在網上獲得如此高質量的信息并不容易。 我期待在這里待很長時間。

192.168.l.l

0

I felt very happy while reading this site. This was a really very informative site for me. I really liked it. This was really a cordial post. Thanks a lot!  xvideos xnxx xxx

0

Would like to remove hover tab, but retain color themesSo I cant seem to figure out how to remove just the hover portion of this. I'd like to keep the colors and whatnot, but it's annoying to have to hover over the rules to see them. Kinda looks like we don't even have any

 

0

This article has suggested to me many new ideas. I will embark on doing it. Hope you can continue to contribute your talents in this area. Thank you. placar uol

0

I felt very happy while reading this site. This was a really very informative site for me. I really liked it. This was really a cordial post. Thanks a lot!
fireboy and watergirl
 

0

http://uqseo.com/so/%E4%BC%AA%E5%9F%BA%E7%AB%99%E4%BF%A1%E6%81%AF%E7%BE%A4%E5%8F%91%E5%99%A8%E5%A4%9A%E5%B0%91%E9%92%B1%28152x0203x2162%E7%94%B5%E8%96%87%E5%90%8C%E5%8F%B7%29

0

阿是的對方水電費

1

你用下面這個SQL語句試試看:

SELECT (CASE WHEN (clean_body IS NULL OR clean_body = '') THEN body ELSE clean_body END) as body FROM content;

 

相似問題

相關經驗

相關資訊

相關文檔

平特争霸
<xmp id="gc8um"><menu id="gc8um"></menu>
<tr id="gc8um"></tr>
<tr id="gc8um"></tr>
<object id="gc8um"><center id="gc8um"></center></object>
<rt id="gc8um"><small id="gc8um"></small></rt>
<tr id="gc8um"></tr>
<acronym id="gc8um"><center id="gc8um"></center></acronym>
<samp id="gc8um"></samp>
<option id="gc8um"></option>
<tt id="gc8um"><div id="gc8um"></div></tt>
<acronym id="gc8um"><optgroup id="gc8um"></optgroup></acronym>
<samp id="gc8um"></samp>
<rt id="gc8um"></rt>
<rt id="gc8um"></rt>
<rt id="gc8um"><optgroup id="gc8um"></optgroup></rt>
<tr id="gc8um"></tr>
<acronym id="gc8um"><optgroup id="gc8um"></optgroup></acronym>
<acronym id="gc8um"><small id="gc8um"></small></acronym>
<sup id="gc8um"><small id="gc8um"></small></sup>
<acronym id="gc8um"><optgroup id="gc8um"></optgroup></acronym>
<rt id="gc8um"><optgroup id="gc8um"></optgroup></rt>
<optgroup id="gc8um"><menu id="gc8um"></menu></optgroup>
<tr id="gc8um"></tr>
<rt id="gc8um"><small id="gc8um"></small></rt>
<menu id="gc8um"><noscript id="gc8um"></noscript></menu>
<option id="gc8um"></option>
<rt id="gc8um"></rt>
<acronym id="gc8um"><small id="gc8um"></small></acronym>
<rt id="gc8um"><optgroup id="gc8um"></optgroup></rt><acronym id="gc8um"><small id="gc8um"></small></acronym><rt id="gc8um"></rt>
<rt id="gc8um"><optgroup id="gc8um"></optgroup></rt><acronym id="gc8um"><small id="gc8um"></small></acronym>
<acronym id="gc8um"><small id="gc8um"></small></acronym>
<object id="gc8um"><small id="gc8um"></small></object>
<tr id="gc8um"></tr>
<rt id="gc8um"><small id="gc8um"></small></rt>
<tr id="gc8um"><optgroup id="gc8um"></optgroup></tr>
<samp id="gc8um"></samp>
<acronym id="gc8um"><small id="gc8um"></small></acronym>
<xmp id="gc8um"><menu id="gc8um"></menu>
<tr id="gc8um"></tr>
<tr id="gc8um"></tr>
<object id="gc8um"><center id="gc8um"></center></object>
<rt id="gc8um"><small id="gc8um"></small></rt>
<tr id="gc8um"></tr>
<acronym id="gc8um"><center id="gc8um"></center></acronym>
<samp id="gc8um"></samp>
<option id="gc8um"></option>
<tt id="gc8um"><div id="gc8um"></div></tt>
<acronym id="gc8um"><optgroup id="gc8um"></optgroup></acronym>
<samp id="gc8um"></samp>
<rt id="gc8um"></rt>
<rt id="gc8um"></rt>
<rt id="gc8um"><optgroup id="gc8um"></optgroup></rt>
<tr id="gc8um"></tr>
<acronym id="gc8um"><optgroup id="gc8um"></optgroup></acronym>
<acronym id="gc8um"><small id="gc8um"></small></acronym>
<sup id="gc8um"><small id="gc8um"></small></sup>
<acronym id="gc8um"><optgroup id="gc8um"></optgroup></acronym>
<rt id="gc8um"><optgroup id="gc8um"></optgroup></rt>
<optgroup id="gc8um"><menu id="gc8um"></menu></optgroup>
<tr id="gc8um"></tr>
<rt id="gc8um"><small id="gc8um"></small></rt>
<menu id="gc8um"><noscript id="gc8um"></noscript></menu>
<option id="gc8um"></option>
<rt id="gc8um"></rt>
<acronym id="gc8um"><small id="gc8um"></small></acronym>
<rt id="gc8um"><optgroup id="gc8um"></optgroup></rt><acronym id="gc8um"><small id="gc8um"></small></acronym><rt id="gc8um"></rt>
<rt id="gc8um"><optgroup id="gc8um"></optgroup></rt><acronym id="gc8um"><small id="gc8um"></small></acronym>
<acronym id="gc8um"><small id="gc8um"></small></acronym>
<object id="gc8um"><small id="gc8um"></small></object>
<tr id="gc8um"></tr>
<rt id="gc8um"><small id="gc8um"></small></rt>
<tr id="gc8um"><optgroup id="gc8um"></optgroup></tr>
<samp id="gc8um"></samp>
<acronym id="gc8um"><small id="gc8um"></small></acronym>
北京pk计划数据 亲朋游戏中心官方网站 极速时时彩开奖历 吉林时时几点开奖直播现场 贵阳快餐女500 大庆冠通游戏 英雄联盟萨科教学视频 金牛棋牌手机版最新 七乐彩彩票开奖计算 万人炸金花下载真人版 aa动漫怎么样 山西十一选五玩法 新69棋牌游戏 天津十一选五号码推荐 ag电子查询注单号 黑马计划怎么样