mysql 筛选问题

mysql提供length()计算字符串的长度，char_length()计算字符串的字符数。

select y_column from tab where char_length(y_column) >100

请自己去验证代码的准确性。

加max,去掉后面的order by 后面的

select max(sum(F_TotalDay)) as SumTodayValue from t_web_reportbysale where (F_TotalType='营业收入') And (F_ComKey='30000548') group by F_ReportDayfrom

海枫科技

SELECT * FORM tables WHERE `price ` between 1000 and 2000

between and 是包含1000和2000

或者

SELECT * FORM tables WHERE `price `>1000 and `price `<2000

---