postgresql7.1 select user_id, first_names, last_name, username from acs_users_all where last_name like '$name%' order by last_name asc select user_id, first_names, last_name, username from acs_users_all where username like '$username%' order by last_name asc