Welcome Guest, Not a member yet? Register   Sign In
Remove values in comma separated list from database
#1

Lets say i have a table in my database there looks like this:

    |-------------------------|
    | id | numbers            |
    |-------------------------|
    |  1 | 1,3,5,7            |
    |  2 | 2,4,6,8            |
    |  3 | 1,2,3,4,5,6,7,6,8  |
    |-------------------------|

I want to remove let us say 4 for all the rows that has the number 4 in the numbers column. What is the sql call to this?
Reply


Messages In This Thread
Remove values in comma separated list from database - by googlemy - 05-24-2017, 11:30 PM



Theme © iAndrew 2016 - Forum software by © MyBB