how do i do a "contains" in select??

[Abhay Burman]

I used the following query
select * from temp_table where column1 = 'value';
this gives me all tuples where column1 is equal to 'value1'

my column1 is of varchar2 type.
what i need is that it should return me all tuples where column1 CONTAINS 'value1'

i'm a newbie to MySQL and SQL.