[mihai11]

Originally Posted by consolegaming

Surely you can just replace thread_id IN (1,2,3) with the conditions you're looking for i.e. if the conditions was that the story had title of 'whatever' and a type of "post" then you'd just put:

UPDATE story SET story_status=2
WHERE title='whatever' AND type='post'

those fields where just examples though as I don't know what conditions you are wanting to be met, if that doesn't sort it I think we'd need to know the conditions you're trying to meet or at least examples of such for us to help any further.

The WHERE clause MUST contain a SELECT from the same table. Please see my example from the first post. This is not supported by MySql.

Anyway, I am thinking to do this the old fashion way, with a PHP script. That means, I will read all the required rows then I will apply the processing to each row. I am thinking that with this I will have better error-control.