[GENERAL] how to check if a database exists programatically

[surabhi.ahuja]

 i have to write a shell script in which i have to check if the database "abc" exists or not

 

how should i do it ? some select query

 

select * from ??? where database_name = 'abc';