SQL Modify returned select value without union

SELECT city,state,
CASE 
 WHEN (city IS NULL OR city='') AND (state IS NULL or state='') THEN ''
 ELSE country
END as country_1
 FROM `table`

SELECT REPLACE(REPLACE(PartNumber, 'MBS1269', 'UFP-1290S'), 'MBS1262', 'UFP-1690S') AS PartNumber... (and so on)

$query = "SELECT username FROM users WHERE UPPER(username) = '".$username1."'";

SELECT u.*
FROM `users` AS u
INNER JOIN `servers` AS s
    ON u.server_name = s.name
WHERE u.username = 'foo'

  INNER JOIN `servers` AS s ON u.server_id = s.server_id

SELECT table1.info AS info, count(*) over () as part_count
FROM table1, table2
WHERE table1.info < table2.info
UNION
SELECT table3.info AS info, count(*) over () 
FROM table3, table4
WHERE table3.info < table4.info;

info | part_count
-----+-----------
   a | 1

info | part_count
-----+-----------
   a | 2 
   b | 2

info | part_count
-----+-----------
   a | 1
   a | 2 
   b | 2

info 
----
   a 
   b