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:
```sqlSELECT CONCAT(column_name, 'extra_text') AS new_column_name, CASE WHEN column_name = 59275927 THEN 1 ELSE 0 END AS case_resultFROM 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]