ecos 输出sql语句 ecstore输出执行语句 ecstore sql查询大全
ecos输出sql语句
ecstore sql查询大全
类型 | 描述 | 示例 |
---|---|---|
than | 大于 | |
小于 | < | |
nequal | 等于 | |
tequal | 等于 | |
sthan | 小于等于 |
$wherec['continuity_end|sthan'] = $params['continuity']; |
bthan | 大于等于 |
$wherec['continuity_begin|bthan'] = $params['continuity']; |
has | 包含 |
$wherec['days|has'] = $params['continuity'].','; |
head | 头部 | |
foot | 尾部 | |
nohas | 不包含 |
$wherec['days|nohas'] = $params['continuity'].','; |
between | 介于之间 |
$wherey['create_time|between'] = array($ydBegin,$ydEnd); |
in | 在之中 |