Need help with simple mysql query

[andré lajoie]

I made a mistake and I lost some data. But there is a solution...

I need to do this:

In table 'catalog'
if 'fieldCode' starts with 'AAA'
then write 'thisText' in 'fieldSubject'

Is this possible ?

Thanks,
Andy