Wallpapers Forums Login

How To Get The Number Of Unique Items In A Column From A Mysql Query

Posted On Wed Dec 08, 2010 By dubars5 In MySQL Forums And Topics Discussions About Open Source Database Forums

hi, i find your tutorials very helpful, but i have a question, i need to know how to get the number of unique items in a column from a mysql query

i have been breaking my head and finally i am giving up

what do you suggest? please reply promptly.

wallpaperama Wed Dec 08, 2010

you use the DISTINCT() in your query.

for example, lets say you have a database of your users, and you want to know which users have their name john, you can use this query like this:

$query= "SELECT DISTINCT(UserName) FROM Users ORDER BY UserName ASC";

hope that helps

Information

Forums »
MySQL Forums And Topics Discussions About Open Source Database »
How To Get The Number Of Unique Items In A Column From A Mysql Query

Title: How To Get The Number Of Unique Items In A Column From A Mysql Query

Description: please show me how to get the number of unique items in a column from a mysql query so i can display all the unique strings from the sql database

Tags: mysql , unique , php , query , database

Info: This Post Has Been Viewed 0 Times Since
Date: Wed Dec 08, 2010
Author dubars5 Received 1 Replies #921

Warning: Session_start() [function.session-start]: Cannot Send Session Cache Limiter

How To Get The Number Of Unique Items In A Column From A Mysql Query

Related Content

Information

Share