query error

[Bhairava Prasad]

select Category_name,Subcategory_name,Title from Foodbazaar_tbl where Foodbazaar_tbl.Category_name Like'food%' UNION ALL select Category_name,Subcategory_name,Title from Weightmanagement_tbl where Weightmanagement_tbl.Category_name Like'food%' buy using this query am getting the output of combination data from all tables. now i require the count of Category_name what is the query for getting the count of category_name to above output plz replay........

bhairava prasad

[Anurag Sinha V]

select COUNT(Category_name) from TableName where Category_name like '%SearchPrefix%'

[Mycroft Holmes]

Select count(*) Records. Category
From (PutYourOriginalQueryHere)
group by Category

Never underestimate the power of human stupidity RAH

[Azarudhin]

hi, select COUNT(Category_name) from TableName where Category_name like '%food%' group by Category

S Azarudhin