liste() {
    if [ $1 -eq 1 ]
    then
        chaine=$2;
    elif [ $1 -eq 3 ]
    then
        chaine=$2"-"$3
    elif [ $1 -eq 4 ]
    then
        chaine=$2"-"$3$4
    elif [ $1 -eq 5 ]
    then
        chaine=$2"-"$3"."$4
    fi
    echo mysql -D kettu-core -e "
SELECT contact_email
FROM users
INNER JOIN memberships ON memberships.connectable_id = users.id
INNER JOIN rents ON rents.connectable_id = users.id
INNER JOIN rooms ON rents.room_id = rooms.id
WHERE (
memberships.end > NOW( )
OR memberships.end =0000 -00 -00
)
AND (
rents.end > NOW( )
OR rents.end IS NULL
)
AND LEFT( rooms.name, $1 ) =  '$chaine';" --skip-column-names --skip-line-numbers --user=mail --password=X7DhNLb --silent
}

liste 3 1 A