hbase shell command - scan and Filter
I've gone through some basics of Filter and scan shell commands in hbase and found that SingleColumnValueFilter is perfect for filter cells based on value. Below command worked for me:
scan 'Mytable', {COLUMNS => ['abc'], FILTER => "SingleColumnValueFilter('abc','drug',=,'binary:avil')",STARTROW => "1100", ENDROW => "1121"}