This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Java Interview Guide and have Anthony DePalma on-line!
See this thread for details.
The moose likes Object Relational Mapping and the fly likes how to write Query in LIKE Clause. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "how to write Query in LIKE Clause." Watch "how to write Query in LIKE Clause." New topic

how to write Query in LIKE Clause.

N.Senthil Kumar
Ranch Hand

Joined: Jul 07, 2009
Posts: 50

is there any possibility to write a query inside Like.

say for eg:

show tables like '%delete from TableA%';

thanks in advance

N.Senthil Kumar
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

Not sure I understand your question - the example you post doesn't make any sense.

It is possible you use the result of a sub query in a like clause in SQL (though this is the ORM forum so I'm not sure its SQL you are after?).

show tables is a specific MySQL command (I think) so I'm not sure what SQL-a-like behaviour it will exhibit.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
I agree. Here's the link:
subject: how to write Query in LIKE Clause.
It's not a secret anymore!