EXISTS predicate?

Question

MySQL

I can't figure out how exists works. Here is an example:

SELECT ship FROM Outcomes os
WHERE EXISTS (SELECT ship 
 FROM Outcomes oa
 WHERE oa.ship = os.ship AND 
 result = 'damaged'
 )

In theory, all ships from outcomes should be selected if exists returns true, why then only those ships where result='damaged' are displayed?

Answer 1

Well, you choose in exists by the condition result = damaged what do you want it to display?
But in general, the meaning is generally incomprehensible, in the same table, why make such a selection.
The same as such a request is obtained

SELECT ship FROM Outcomes os
WHERE  result = 'damaged'