Select and update SQL
<p>I am extracting data using the query below, which pulls about 200 users.</p>

<pre><code>Select 
    users.user_id, users.first_name, users.last_name,
    user_profiles.role, user_profiles.last_modified, 
    user_profiles.last_modified_by
From
    users
Inner Join
    user_profiles on user_profiles.user_id = users.user_id
Where 
    project_id = '28'
    and role like 'customer__bread__fsubmit__fedit__bdefault'
order by 
    last_modified
</code></pre>

<p>I now want to update the role to a new role of : </p>

<pre><code>IBS__bGlobal__bCustomer__b__P__bTLO__b__p
</code></pre>

<p>How can I incorporate that role into the select query?</p>

<p>Your assistance would be appreciated.</p>