I've a table named
comment is a field where comment will be stored.
Now I want to find
-1 within that comment.
-1 should be independent. That is, it should not be joined with other word like
I just want to know whether a comment contains
I'm currently using
where instr(comment,' -1 ') != 0.
I want this because, users can downvote a post by commenting with
Any ideas on how to do this even more efficiently.
I'm using MySql 5.1, if that helps.
I want to select all rows that contain