首頁猿問你好，求解，關(guān)于在mysql中用l...

你好，求解，關(guān)于在mysql中用like實(shí)現(xiàn)多條件模糊查詢?內(nèi)容太多，請看下面

C++ MySQL

眼眸繁星 2021-06-02 11:07:31

SELECT BigCategory,SmallCategory,Model_No,1 'yuefen',SUM(case when BizType='P' then MONTH1Num end ) as P,SUM(case when BizType='S' then MONTH1Num end ) as S,SUM(case when BizType='I' then MONTH1Num end ) as I,SUM(case when BizType='P' then MONTH1Num end )- SUM(case when BizType='S' then MONTH1Num end )-SUM(case when BizType='I' then MONTH1Num end ) PanDianFROM t_testWHERE Model_No like 'iphone4s%'OR WHERE Model_No like 'v480%'SELECT BigCategory,SmallCategory,Model_No,1 'yuefen',SUM(case when BizType='P' then MONTH1Num end ) as P,SUM(case when BizType='S' then MONTH1Num end ) as S,SUM(case when BizType='I' then MONTH1Num end ) as I,SUM(case when BizType='P' then MONTH1Num end )- SUM(case when BizType='S' then MONTH1Num end )-SUM(case when BizType='I' then MONTH1Num end ) PanDianFROM t_testWHERE Model_No like 'iphone4s%'OR WHERE Model_No like 'v480%'GROUP BY BigCategory,SmallCategory,Model_No;我這段代碼為什么老是報(bào)錯(cuò)，用的是mysql數(shù)據(jù)庫

查看完整描述

2 回答

紅糖糍粑

TA貢獻(xiàn)1815條經(jīng)驗(yàn) 獲得超6個(gè)贊

你的代碼有兩個(gè) where

WHERE Model_No like 'iphone4s%'
OR WHERE Model_No like 'v480%'

改成這樣

WHERE Model_No like 'iphone4s%'
OR Model_No like 'v480%'

反對回復(fù) 2021-06-07

幕布斯7119047

TA貢獻(xiàn)1794條經(jīng)驗(yàn) 獲得超8個(gè)贊

select * from mm where name like '王%' or name like '張%' or name like '李%'
或者
select name from table where name like '王%'
union
select name from table where name like '張%'
union
select name from table where name like '李%'