Re: Sorting Tables

2008-01-02 Thread Victor Subervi
Ah, yes. Thank you. On Jan 2, 2008 11:51 AM, Baron Schwartz <[EMAIL PROTECTED]> wrote: > Hi, > > Try this: > > SHOW TABLES LIKE 'xyz%'; > > Baron > > On Jan 2, 2008 10:17 AM, Victor Subervi <[EMAIL PROTECTED]> wrote: > > Either I don't understand your reply or I miscommunicated. How do I do > tha

Re: Sorting Tables

2008-01-02 Thread Baron Schwartz
Hi, Try this: SHOW TABLES LIKE 'xyz%'; Baron On Jan 2, 2008 10:17 AM, Victor Subervi <[EMAIL PROTECTED]> wrote: > Either I don't understand your reply or I miscommunicated. How do I do that > when it is the tables that I want to select; that is *all* tables that are > called "xyz$variable", whe

Re: Sorting Tables

2008-01-02 Thread Victor Subervi
Either I don't understand your reply or I miscommunicated. How do I do that when it is the tables that I want to select; that is *all* tables that are called "xyz$variable", where "variable" is unknown but all tables begin "xys$"? TIA, Victor On Dec 31, 2007 3:59 PM, mos <[EMAIL PROTECTED]> wrote:

Re: Sorting Tables

2007-12-31 Thread mos
At 12:51 PM 12/31/2007, you wrote: Hi; Is it possible to sort tables within a given database? How? TIA, Victor Victor, You mean physically sort the table based on a field or key so you don't have to do an Order By clause each time you do a Select? Not really because the order of the tabl