Effective update statement
<p>I have table <code>Value_table</code> and column <code>value</code>
I need to update <code>value</code> column as 'Hi' if any <code>value</code> column exists with 'bye'
I wrote query</p>

<pre><code>UPDATE Value_table
SET value = 'Hi'
WHERE value_id
IN
(
    SELECT
        value_id
    FROM 
        Value_table 
    WHERE 
        value = 'bye'
)
</code></pre>

<p>It works fine.Now since I'm using the same table in sub query can we make any other way to make this statement in more efficient.?</p>