Select from a dbase that has many table

[Anon]

hello to everybody , how can i search a word in a database mysql ?
ex : i want to search the word 'box' in my database:
select * from table,table2,... where 'namefield' like 'myvar'

must i specify all the name of my fields ?
thanks in advance
Attilio