A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Android Security Essentials Live Lessons
this week in the
Object Relational Mapping
how to write Query in LIKE Clause.
Joined: Jul 07, 2009
Mar 18, 2011 08:05:37
is there any possibility to write a query inside Like.
say for eg:
show tables like '%delete from TableA%';
thanks in advance
Joined: Apr 14, 2004
Mar 18, 2011 08:38:20
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.
Did you see how Paul
cut 87% off of his electric heat bill with 82 watts of micro heaters
subject: how to write Query in LIKE Clause.
ORA-01009-missing mandatory parameter
hibernate left join not working
Multiple "select" in one query
How to insert email id in table
file uploading basing on a category
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014