MySql select * returns no results - any ideas?

[cazgh]

Am running a select * query on a MySql database but returning no results. I can describe the table and back up the table. I can also specify the individual columns and return results, but if I list all columns by their name that too returns no results.

Am having difficulty finding any answers - has anybody experienced this before and could possibly point me in the right direction please?

[eelixduppy]

What is your query exactly and are you returning any errors? how are you querying the database? Directly through a command prompt? Something else? What you are experiencing seems a little odd.