MYSQL LOWER() And UPPER() Functions

MYSQL LOWER() And UPPER() Functions

The upper() and lower() functions with mySQL can be used to change selected data into lower case or upper case values. These functions are very similar to PHP strtolower() and strtoupper() functions.

include('connect.inc');
$db = public_db_connect();
//MYSQL LOWER() and UPPER() Functions

$command = "SELECT DISTINCT LOWER(firstname) as first, UPPER(lastname) as last, LOWER(Email) as email FROM table_sort WHERE id >0 ORDER BY last ASC" ;
$result = mysqli_query($db, $command);
while($row = mysqli_fetch_assoc($result)){
$firstname = $row['first'];
$lastname = $row['last'];
$email = $row['email'];
echo $firstname."-".$lastname."-".$email."<br/>";
}