Update column if another column contains a string

Question

I have a table that contains three columns.

column1        column2     column3 
mytestdata     test 
myotherdata    test 

I want to insert 'somestring' into column3 if column1 contains the value in column2

The result would look like:

column1        column2     column3 
mytestdata     test        'somestring' 
myotherdata    test 

Answer 1

SQL Server:

UPDATE myTable
   SET column3 = 'somestring'
 WHERE column1 LIKE '%' + column2 + '%'

Answer 2

SQL Server:

UPDATE theTable SET column3 = 'somestring' 
WHERE CHARINDEX (column2, column1) > 0