计算mysql中一列的不同字符串

Question

I have a situation where I have to count number of strings of different type in one column of a table, e.g. a column would have values such as :

apple
apple
apple
orange
orange
banana
banana
banana
banana

So I need to count the strings only of different type, that means query should give count result 3. What can be the ideal query for this?

Answer 1

You can count distinct values like this:

SELECT COUNT(DISTINCT column_name) FROM table_name;