I am unable to run count(*) with multiple where conditions in mysql.
I am running
SELECT count(*) as total FROM speed_videos WHERE `section_id` = 2 and `status` = 1
giving no resuts even it has results. but same query with any one where condition giving results.
Is issue from godaddy. i called godaddy support. there are just dummy.
Hi @sankarsuda. I'm not a MySql developer, but I'm guessing it would be easier for others to post a suggestion if they have more information about your particular database, like what it's structure is. It would probably also be helpful to know what version of MySql you are using. Hope you're able to figure it out.
Yes, as @JesseW said, it would be helpful to know the structure of your table to see if the sql query is right.
Also, have you changed anything in your server / account that may triggered the issue?
If your query is ran by PHP, have you checked that all your mysql modules are active?
Also, what happens if you run the query through phpMyAdmin or mysql command from shell?
Hope it helps!