How to delete usergroup id
 

How to delete usergroup id from user table for a specific user ..
I mean i need a mysql query to delete a vip userid if he or she's subscription is cancelled..
so i have to remove the specific usergroup id from mysql--->my database--->specific user table..

can any one hel please ...
thank you

suppose vip usergroup id= 49
and user's main usergroup id = 5
and in membergroupids =49,50,89

The 49 is inserted in membergroupids as he have purchased the subscription.
now when ever the susbcription is cancelled which query should be done to delete 49 from his
membergroupids

:D:D

Would be easier using PHP then trying to do this in a single MySQL query i guess.

see i am quite new in php and mysql so any kind of help will be use full if oyu kidly give a hint how to do this thank you ..

Can any one help me here i just wanna create a corn job to do this so it will require php i know.but if any one can give me any hint thank you

Read from the database. Use explode() to turn the comma seperated list of membergroupids into an array. Remove the element you don't need anymore. Use implode() to turn it into a comma sepratd list again and write back to database.

thanks thank you very much i am giving it a try ....