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
Post a Comment