Is the Mazda 323 1.8 Familia worth buying?

First of all, hello everyone, Given today's conditions, is a '98 Mazda 323 Familia 1.8 worth buying? How is its automatic transmission? I want to use it for a long time, 5-6 years — do you think it's a good choice?