A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
video training course 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.
I agree. Here's the link:
subject: how to write Query in LIKE Clause.
How to insert email id in table
file uploading basing on a category
Multiple "select" in one query
hibernate left join not working
ORA-01009-missing mandatory parameter
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015