MySQL Count AND SELECT

Hey Guys.

I was just wondering if there was a way to open a connection that has a COUNT() function in there as well as the normal fields.

If it were possible, I’m guessing it would be something like…

Select COUNT(*) as total from events AND select * from events;

I’m new to MySQL, so dont yell at me too badly :slight_smile: