联系官方销售客服
1835022288
028-61286886
统计数量标签是不是不支持like查询
{count action=sql sql='SELECT * FROM dr_1_share_category WHERE `dr_1_share_category`.`pid` IN (532) ' } {$debug_count}
这种的where条件就可以
{count action=sql sql='SELECT * FROM dr_1_share_category WHERE `dr_1_share_category`.`name` LIKE '%关键词%' ' } {$debug_count}
或者
{count action=sql sql='SELECT * FROM dr_1_share_category WHERE name LIKE '%关键词%' ' } {$debug_count}
这样的where条件就报错了 ,好像 '%关键词%' 没传递过去一样
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#SQL:SELECT count(*) as ct FROM dr_1_share_category where `dr_1_share_category`.`name` LIKE
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
#SQL:SELECT count(*) as ct FROM dr_1_share_category WHERE name LIKE
是不是要添加转意符,怎么弄?指点下