MYSQL : WHERE and CHAR_LENGTH() with explanation. Good Luck 👍✨
\n# Write your MySQL query statement below\n/**\nONE TABLE : Tweets\ntweet_id is the primary key.\nTweets table contains all the tweets in a social media app.\n
```\n# Write your MySQL query statement below\n/**\nONE TABLE : Tweets\ntweet_id is the primary key.\nTweets table contains all the tweets in a social media app.\n\nPROBLEM: find the IDs of the invalid tweets.tweet is invalid if the number of characters used in the content of the tweet is strictly greater than 15.\n\nSTEPS:\n    1. WHERE CHAR_LENGTH(content) >15\n\n\nNote: Difference blw CHAR_LENGTH() and LENGH()\n\nCHAR_LENGTH()  - measured in characters of a string.\nLENGH() -  measured in bytes of a string.\n*/\n\nSELECT \n    tweet_id\nFROM Tweets\nWHERE CHAR_LENGTH(content) > 15 \n```\n
['MySQL']