sql - How can I insert a value in a determined column with and statment? -


please fix question me? don't know how ask =/

i have 2 main columns:

contest(pk) , result , other column named resultcheck

i need insert value "1" in column resultcheck result has statement like.

for example

contest   result 1          1,2,3,4,5 2          2,3,4,5,6 

i want insert resultcheck values 1 result '%2,3%'

how can that?

and in end have result:

contest    result      resultcheck 1          1,2,3,4,5   1 2          2,3,4,5,6   1 3          5,6,7,8,9   null 

you should listen @teresko's advice modelling data correctly (apart english bit) , otherwise answer is

update tablename set resultcheck = 1 result "%2,3%" 

Comments