|
Do you have a column called "total" in your "Recipe" table? If not it won't work, and even if you do it's probably not doing what you think.
You probably want something more like "SELECT COUNT(1) AS total FROM Recipe WHERE Category REGEXP 'diabetic'"
|