Quiro
Question / Answer

Select concatconcatqpjqqcase when 59275927 then 1 else 0 endqvjvq

Vertaald door AI (EN). Toon origineel (NL)


It seems that you are trying to formulate an SQL query, but the syntax is not correct. Here is a corrected version that can reflect the intent of your question.

If you want to check a value and create a new column based on that check, the SQL query would look something like this:

```sql
SELECT
CONCAT(column_name, 'extra_text') AS new_column_name,
CASE
WHEN column_name = 59275927 THEN 1
ELSE 0
END AS case_result
FROM
your_table_name;
```

In this example, you would replace `column_name` with the name of the column you want to check, and `your_table_name` with the name of your table. The `CONCAT` function concatenates text, and the `CASE` expression returns 1 or 0 depending on the condition.

If you need more specific help, let me know!


Google Search also contributes even further

[edit this question / answer]