Search all tables within one database in one query

[[email protected]]

The Salary database's table structure is as below;

 

Salary

A B C D E

a1        b1          c1

a2 b2 .

a3 . .

. .

.

.

.

an

 

what if i need to search one specific string in all data fields

in just only one query,

 

This is what i like to do;

 

SELECT * FROM A, B, C, D, E WHERE * LIKE 'aus%'   

 

 

....  something like that!! 

What exactly the query it should be?  any one knows???  I'm using MYSQL 5

[fenway]

Either use a full text index to cover all 5 columns, or use a lot of LIKE clauses.