Help?

[Hialls]

Too tired, can't think :D
update user set membergroupids=concat_ws(',', 'A', membergroupids) WHERE userid = 'X'

Would add userid X, to membergroup A. But how would i remove user X from membergroup A

[Zubaz]

I don't think you can do that in a query, you'd have to pull the info out, parse it in php and then update.

[Dean C]

If you can explain what you're trying to do maybe we can help a little easier :)

[Hialls]

Ah ok Dean, basically i've made/making a membergroupid leaders and i want the leader to beable to add/remove members from there squad. But i can't work out how to remove a user from membergroupid's.

Im just wondering if there is a mysql query to remove a number from the membergroupid column.

[Dean C]

Ok after looking into it there's really no easy way of doing it with MySQL. What i'd suggest doing is rebuilding the list using PHP. Explode the commas, find the usergroupid in the array, remove it, rebuild array using implode and then updated.