使用PHP distinct从mysql中获取所有唯一数据

Question

I am stuck on fetching unique data from MySql Database by PHP Distinct. I want to fetch all the data from the table but in a particular field 'ccTitle' should remove duplicate entries. My Query is as follows-

"SELECT DISTINCT(*) FROM conferencecreate WHERE ccFlag = 1 AND ccStartingDate >= '$nowTime'"

But it's not working. I discovered Distinct is working individually for a field. Is there another to solve this issue?

Let me know please.

TQ

Answer 1

You are looking for this query:

SELECT *
TABLE table
GROUP BY column

You can write this query with DISTINCT statement like that:

SELECT DISTINCT ON column *
FROM table