SELECT
	id
FROM
	address
WHERE
	street1 = '123 Street St'
 
 
SELECT
	id
FROM
	address
WHERE
	street1 = '123 STREET ST'
 
 
SELECT
	id
FROM
	address
WHERE
	street1 = '123 StReEt sT'