How to optimize statements with greater than condition in MySQL.Example:

Code:
SELECT
	PDB.PHONENUMBER,
	PD.TEMP_VAR2
FROM
	db_sub_warehouse_b pdb
	JOIN db_sub_warehouse pd ON pdb.subwarehouse_id = pd.subwarehouse_id
	JOIN pd_reportex_b prb ON prb.iccid >= rtrim( pdb.temp_var1 ) 
	AND prb.iccid <= rtrim( pdb.temp_var2 )'
WHERE
	1 = 1 
	AND pd.billcode = 'SW20190
...