WHERE is the primary filter clause in any type of SQL database.
Instead of selecting all the rows from a table, we can select particular rows using WHERE.

Syntax:
```SELECT columns
FROM table
WHERE condition
```

condition may contain relational operators, joins etc.

Example:
Principal of a college wants to know the details of a student named 'Maria' whose student_id is 1324.
So, Principal needs only the details of Maria with student_id 1324.
Consider the table tbl_student for this example.
```SELECT name, address, year, section, native, hostelite
FROM tbl_student
WHERE student_id=1324
```

```SELECT name, address, year, section, native, hostelite
FROM tbl_student
WHERE student_id=1324 and name='Maria'
```
{"ft_lang_label":"__label__en","ft_lang_prob":0.5424448,"math_prob":0.6023912,"size":262,"snap":"2019-43-2019-47","text_gpt3_token_len":66,"char_repetition_ratio":0.15116279,"word_repetition_ratio":0.5,"special_character_ratio":0.22137405,"punctuation_ratio":0.22222222,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.9745017,"pos_list":[0],"im_url_duplicate_count":[null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2019-11-18T23:45:03Z\",\"WARC-Record-ID\":\"<urn:uuid:b9602f67-1680-49dc-8a75-4b4c4f3ac4cc>\",\"Content-Length\":\"23909\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:8daa1924-2a8f-4479-8ed9-38b2fb05fea0>\",\"WARC-Concurrent-To\":\"<urn:uuid:71e1d009-6ce8-4a80-b4f7-0210be8a3a8c>\",\"WARC-IP-Address\":\"174.136.89.188\",\"WARC-Target-URI\":\"https://forgetcode.com/Teradata/1255-WHERE\",\"WARC-Payload-Digest\":\"sha1:F4CHUYFATP6P6TXB5JGCUP77HPZ4KSBX\",\"WARC-Block-Digest\":\"sha1:MAMK5HDIKJFYDOC7CUBNYBPGG4QJAY2G\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2019/CC-MAIN-2019-47/CC-MAIN-2019-47_segments_1573496669868.3_warc_CC-MAIN-20191118232526-20191119020526-00238.warc.gz\"}"}