Query Statement

[prakhar]

I want to search for a keyword in all the columns of my database. So please help me for a query to execute like:

statement.executeQuery("select * from BOOKS where Title like '%"+Criteria+"%'");

Instead of only title i want to search in all the fields.

If the above is not possible then what is wrong the the following:

statement.executeQuery("select * from BOOKS where Title like '%"+Criteria+"%' Or Author like '%"+Criteria+"%' Or Publisher like '%"+Criteria+"%' Or Type like '%"+Criteria+"%' Or Genre like '%"+Criteria+"%' Or Keywords like '%"+Criteria+"%' Or Comment like '%"+Criteria+"%' Or Category like '%"+Criteria+"%' Or BookSubject like '%"+Criteria+"%' Or Series like '%"+Criteria+"%' Or Illustrator like '%"+Criteria+"%' Or Language like '%"+Criteria+"%' Or Location like '%"+Criteria+"%'");

[Kinda Electroni]

Hello,
Is this Oracle or Java?
It looks like Oracle more than Java.