Hrm. Closest I can think of is

EXPLAIN SELECT * FROM demo WHERE name LIKE 'user_access';

I think this is what you mean.

Adam Hooper
[EMAIL PROTECTED]

On Fri, 31 May 2002 08:44:49 -0700
marc malacarme <[EMAIL PROTECTED]> wrote:

> I canıt seem to make any of the describe or show queries work when I apply a
> search statement:
> Query=show table status from demo;
> Works fine. Now Iım trying to get info from only one table:
> Query=show table status from demo where name like "user_access";
> Does no work.
> 
> Thank You 
> 

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to