How to use less than < and greater than > symbols in metamug XML

Question

How to use less than "<" and greater than ">" symbols in metamug XML in the resource file and SQL console

select * 
from tbl_reservation 
where fare > 100 
  and fare < 50000

Answer 1

Firstly < and > works in SQL console

With < >

Without < >

But to use them in resource file you'll have to escape them as per the below table
For more as per these guideline
So your query will be

select * from tbl_reservation where fare lt 100 and fare gt 50000