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