Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

Tags:

sql

xml

metamug

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
like image 230
SurajRajesh Avatar asked Jan 05 '23 05:01

SurajRajesh


1 Answers

Firstly < and > works in SQL console

With < > With

Without < > Without

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

select * from tbl_reservation where fare lt 100 and fare gt 50000
like image 106
Kainix Avatar answered Jan 07 '23 22:01

Kainix