Count rows returned from mysql query with distinct values [duplicate]

Question

I am tryimg to count the number of rows returned from a mysql query using the code below. I cannot get the count despite trying many things. Could the problem be distinct vales. Here is my query

SELECT DISTINCT SUBSTRING_INDEX(location,'>',-2), count(*) as location FROM tablename

unclexo · Accepted Answer · 2020-01-26 08:40:23Z

0

Use the count() as the following:

SELECT COUNT(DISTINCT column_name) FROM table_name;

May be the following queries would answer exactly what you want.

SELECT COUNT(DISTINCT SUBSTRING_INDEX(location, '>', -2)) as location 
FROM table_name;

Or

SELECT COUNT(DISTINCT location) as total 
FROM table_name
WHERE SUBSTRING_INDEX(location, '>', -2) != location;

edited Jan 26, 2020 at 8:40

answered Jan 26, 2020 at 7:45

unclexo

3,9812 gold badges22 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

mickmackusa Over a year ago

Do you think this question might have been asked on Stackoverflow before? Basic questions are almost always duplicates, please flag accordingly.

unclexo Over a year ago

It has not been exactly answered. I think so. I didn't find myself any answer that can satisfy this one. I've your words in my head. So don't worry!

Collectives™ on Stack Overflow

Count rows returned from mysql query with distinct values [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related