SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
select trim(both '"' from city->'en') as city, airport_code as airport_code from airports_data order by city->'en'; ; select * from query_cost('select trim(both ''"'' from city->''en'') as city, airport_code as airport_code from airports_data order by city->''en'';');

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear