thanks for it

Thanx for it

great work ... thankx for it

nice ... thanks for it

great work !!! Thanks for it

let me look .. thanks for it

thanks for it

thanks for it

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
 

great work many thanks for it

Interesting ...  never heard before ... thanks for it

nice thanks for this handy tool

let me test it out thanks for it

thanks for it

is it really working ? or is it crap ? thanks for it