DQL Query contains ampersand (&) Symbol
I am using below query to fetch metadata using D2FS. However folder name contains ampersand (&) Symbol and due to this it's not giving me result. Kindly let me know how can i resolve this issue?
select * from gom_engineering where folder ('/CNAEP/GOMBU/Engineering & Operations/MC - Mississippi Canyon(Blind Faith)/650 A - Block 650 Facility A/Engineering',descend)