mysqlsqlmariadbmariasql

MySQL Select when not exist return 1

I have a problem in the MySQL Query:

How can i SELECT something but when it errors because it doesn´t exist it should return a value like 1 or something else.

My Query

SELECT License FROM fivem_auth WHERE IP = '34.45.34.77';
Solution

  • You can UNION your query with a query that returns the default if the row doesn't exist.

    SELECT License FROM fivem_auth WHERE IP = '34.45.34.77'
UNION ALL
SELECT 1 FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM fivem_auth WHERE IP = '34.45.34.77')