Selecting Unique value for mysql database

[rstewar]

Is there a way to select only unique records from a database, where only one value is unique? I want to be able to select unique values for 'university_1', but 'latitude' and 'longitude' do not have to be unique.

$sql = "SELECT university_1, latitude, longitude FROM stores ";
        $sql .= "WHERE state='$state' AND ";
        $sql .= "latitude BETWEEN '$min_lat' AND '$max_lat'
               AND longitude BETWEEN '$min_lon' AND '$max_lon'
               AND approved=1 AND status=1";

 

Thanks for any help.

[Hybride]

Try:

$sql = "SELECT DISTINCT(university_1), latitude, longitude FROM stores ";

[rstewar]

Works great. Can't believe I didn't think of that. Thanks