Hi,
If you're only looking for the record that has the columnid value of 0, then this is better:
select * from table where columnid = '0';
You can't really do:
select * from table where columnid like '0','1','2';
If you are trying to retrieve records that have a columnid value of 0 1 or 2, then this would work:
select * from table where columnid IN ('0','1','2');
... and if columnid is defined as an integer data type, then you would be better with:
select * from table where columnid IN (0,1,2);
Hope it helps.