Need help -> SQL Problem

[Skully2018]

Hello... I need your help with a SQL problem

I created a small table to illustrate it

I would like to filter out the entries that do NOT have CST as a time zone.

Then only 3 (Jacky) would be left.

The value “0” should then be written in the “Visible” column.
 

 ID | Name         | Language  | Country | Time Zone  | Phone      | Visible | Date
----+--------------+-----------+---------+------------+------------+---------|---------
 01 | John Smith   | German    | Germany |     UTC    | +49 xxxxxx |    1    | 12/09/24
----+--------------+-----------+---------+------------+------------+---------|---------
 02 | Lou Vega     | German    | Spain   |     UTC    | +32 xxxxxx |    1    | 23/01/99
----+--------------+-----------+---------+------------+------------+---------|---------
 03 | Jacky Brown  | Turkiye   | Ukrain  |     CST    | +21 xxxxxx |    1    | 25/01/22
----+--------------+-----------+---------+------------+------------+---------|---------
 04 | Monica L.    | Island    | China   |     UTC    | +77 xxxxxx |    1    | ß1/01/01
----+--------------+-----------+---------+------------+------------+---------|---------
....

I tried it with:
 

UPDATE [User_DB] SET [visible]=0 WHERE [TimeZone] NOT LIKE '%CST%';

I tried it, but somehow I can't get any further.

Maybe someone is into SQL Fit and can give me a solution

Thanks in advance

Cheers
 

[RandomBoyz]

Hello... I need your help with a SQL problem

I created a small table to illustrate it

I would like to filter out the entries that do NOT have CST as a time zone.

Then only 3 (Jacky) would be left.

The value “0” should then be written in the “Visible” column.
 

 ID | Name         | Language  | Country | Time Zone  | Phone      | Visible | Date
----+--------------+-----------+---------+------------+------------+---------|---------
 01 | John Smith   | German    | Germany |     UTC    | +49 xxxxxx |    1    | 12/09/24
----+--------------+-----------+---------+------------+------------+---------|---------
 02 | Lou Vega     | German    | Spain   |     UTC    | +32 xxxxxx |    1    | 23/01/99
----+--------------+-----------+---------+------------+------------+---------|---------
 03 | Jacky Brown  | Turkiye   | Ukrain  |     CST    | +21 xxxxxx |    1    | 25/01/22
----+--------------+-----------+---------+------------+------------+---------|---------
 04 | Monica L.    | Island    | China   |     UTC    | +77 xxxxxx |    1    | ß1/01/01
----+--------------+-----------+---------+------------+------------+---------|---------
....

I tried it with:
 

UPDATE [User_DB] SET [visible]=0 WHERE [TimeZone] NOT LIKE '%CST%';

I tried it, but somehow I can't get any further.

Maybe someone is into SQL Fit and can give me a solution

Thanks in advance

Cheers
 

Did you manage to fix it?

[Skully2018]

UPDATE deine_tabelle
SET Visible = 0
WHERE "Time Zone" != 'CST';

thats it