I've got a generic group that all of my users must be a part of. However, I have a chunk of users that aren't for some reason or another. So, I did a query to see who they are
<br />SELECT * <br />FROM `w3t_Users` <br />WHERE U_Groups NOT <br />LIKE "%-3-%"
Now I need to do a query to manually enter -3- for each one that doesn't have that group. I would use "Update w3t_Users; set U_Groups="-3-"; but that would overwright the groups that are already there.
So what is the SQL statment that would ADD -3- without damaging what is already there?
