dorpbn1027 2015-05-05 14:23
浏览 33

存储过程删除like并放入where子句

i want to filter posts on stored procedure,but it's not working on where clause,if i'm using like function it should working

code for like :

 SELECT *, MAX(score) FROM temp1 where temp1.hashTag like CONCAT('%',searchterm,'%') GROUP BY OriginalPostId limit pageno,10;

code for where :

 SELECT *, MAX(score) FROM `temp1` where `temp1`.`hashTag` = searchterm GROUP BY OriginalPostId limit pageno,1;

but i don't want like,i want exact value on where.

  • 写回答

0条回答 默认 最新

    报告相同问题?