ALERT!
Click here to register with a few steps and explore all our cool stuff we have to offer!

Jump to content

 
Skully2018's Photo
Skully2018 Veteran
16
Reputation
961

Likes

Information

Username Changes:
Joined: 02-02-18
Date of Birth: 53 years old - February 9, 1971
Last Visit: Apr 14 2024 11:11 AM
Profile Views: 91,536
Discord: SkullSplitter#4429

Statistics

Posts: 1646
Leecher Value: 2104
Likes:
961
Reputation: 16
Warning level: Low
Threads: 243
Credits: 0
Vouches: 0
Trust Scan: Info
Reported posts: 3
Shouts
Loading...

Groups

Contributor

Signature

-= I'm allergic to stupidity, it makes me break out in a rash of sarcasm =-

 

-+-+-+-+-+-+-+-+-+-+-+-

 

View my Uploads !!!


-+-+-+-+-+-+-+-+-+-+-+-

Sorry but most of my uploads up to mid 2021 have been deleted by Mega.nz !!!
In most cases, I have a newer version for you ;)

Last visitors



Need help -> SQL Problem

16 January 2024 - 04:18 AM

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
 


-->