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.