Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to write Query in LIKE Clause.

 
N.Senthil Kumar
Ranch Hand
Posts: 50
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

is there any possibility to write a query inside Like.

say for eg:

show tables like '%delete from TableA%';

thanks in advance
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic