Is it possible to only describe one field?
I've got a field called `state` in a table called `users`, so I would have thought I could use the statement:-
Describe `users` where `Field` = 'state';
But all I get back is:-
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where `Field` = 'state'' at line 1
If I use the statement:-
I get all the rows, but I only want the 1 row returned.
Any ideas how I can complete this?