sqlite:有没有办法在SELECT子句中创建条件OR / COALESCE?

前端之家收集整理的这篇文章主要介绍了sqlite:有没有办法在SELECT子句中创建条件OR / COALESCE?前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
我有以下观点:

  1. CREATE VIEW FilmTableView AS
  2.  
  3. SELECT (TitleSP || " / " || TitleEN) as Title,CompanyName,CoverURI,CompanyFilmRelation.CompanyId,CompanyFilmRelation.FilmId
  4.  
  5. FROM Film
  6. JOIN CompanyFilmRelation on CompanyFilmRelation.FilmId = Film.FilmId
  7. JOIN Company on CompanyFilmRelation.CompanyId = Company.CompanyId
  8.  
  9. ORDER BY Title;

但我最终可能会得到TitleSP或TitleEN为空的记录.在这种情况下,我只想包含哪个列不为null而不包含“/”.

有没有办法做到这一点?也就是说,遵循以下逻辑:

  1. if(TitleSP && TitleEN)
  2. select (TitleSP || " / " || TitleEN) as Title
  3. else
  4. select (TitleSP ? TitleSP : TitleEn) as Title

解决方法

  1. SELECT CASE WHEN (TitleSP = '' OR TitleSP IS NULL)
  2. THEN COALESCE(TitleEN,'')
  3. WHEN (TitleEN = '' OR TitleEN IS NULL)
  4. THEN TitleSP
  5. ELSE (TitleSP || ' / ' || TitleEN)
  6. END AS Title,...

猜你在找的Sqlite相关文章