sinat_38020023的博客

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'XXXX.T.ID' which is not functionally dependent on c...

1、多条件like查询 like '%a%' or like '%b%' or like '%c%' 用regexp ‘a|b|c’ select * from onetime where red regexp ',1,|,2,|,3,|,4,|,5,|,6,' 2、mysql 某字段满足6个条件的至少3个 select *from onetime where red regexp...