wood burning stoves 2.0*
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 The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript 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
Author

how to write Query in LIKE Clause.

N.Senthil Kumar
Ranch Hand

Joined: Jul 07, 2009
Posts: 50
Hi,

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
Bartender

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: http://aspose.com/file-tools
 
subject: how to write Query in LIKE Clause.