How To Get The Number Of Unique Items In A Column From A Mysql Query
- Forums
- MySQL
- How To Get The Number Of Unique Items In A Column From A Mysql Query
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 [921], Last Updated: Tue Feb 07, 2023
dubars5
Wed Dec 08, 2010
1 Comments
681 Visits
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.
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
https://www.wallpaperama.com/forums/_zxmxxa.html