sql query help needed

hi
Please can anyone help?

I have firebird db and I have 150 tables. I need to update some field with query.

This snetence is just works fine, what I need is: I need to update all the tables.

UPDATE MYTABLE SET TBL_FIELD = 'Man' WHERE TBL_FIELD = 'Women'

Code (markup):

When I put all table names like this one


UPDATE MYTABLE,YOURTABEL, HISTABLE,BESTTABE etc.


this time sql error happens because not all the tables have this field TBL_FIELD



What is the easiest way to do this.

thank you in advance.

 

I can help, however I need the structure of your tables. If you could dump that, it'd be good.