your solution

[hamza]

select * from tab where like '%$var%';

Chill

[rajivgonsalves]

you forgot the column name  ???

 

should be

 

select * from tab where columnname like '%$var%';