Effect
Frightened and Fearful
Frightened prevents movement, while Fear makes a creature flee its source. These are different conditions.
Both impose Disadvantage on attack rolls and ability checks. Holding an enemy in place and making it run away have different tactical uses.
Read the specific condition and the spell that applies it. Check the saving throw and any opportunities to end the effect.