{"id":27217,"date":"2022-12-01T12:00:21","date_gmt":"2022-12-01T12:00:21","guid":{"rendered":"https:\/\/kb.hostatom.com\/?p=27217"},"modified":"2025-11-11T01:37:26","modified_gmt":"2025-11-11T01:37:26","slug":"sql-where-clause","status":"publish","type":"post","link":"https:\/\/kb.hostatom.com\/lesson\/27217\/","title":{"rendered":"SQL\u00a0WHERE\u00a0Clause"},"content":{"rendered":"\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07 \u0e15\u0e32\u0e23\u0e32\u0e07 Customers<\/strong> \u0e17\u0e35\u0e48\u0e43\u0e0a\u0e49\u0e43\u0e19\u0e01\u0e32\u0e23\u0e2d\u0e18\u0e34\u0e1a\u0e32\u0e22:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t\t\t\t\t\t\u0e01\u0e48\u0e2d\u0e19\u0e08\u0e30\u0e40\u0e23\u0e35\u0e22\u0e19\u0e23\u0e39\u0e49\u0e01\u0e32\u0e23\u0e43\u0e0a\u0e49\u0e04\u0e33\u0e2a\u0e31\u0e48\u0e07 WHERE<\/code> \u0e21\u0e32\u0e14\u0e39\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e15\u0e32\u0e23\u0e32\u0e07\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e35\u0e48\u0e08\u0e30\u0e43\u0e0a\u0e49\u0e01\u0e31\u0e19\u0e01\u0e48\u0e2d\u0e19\n\u0e19\u0e35\u0e48\u0e04\u0e37\u0e2d\u0e2a\u0e48\u0e27\u0e19\u0e2b\u0e19\u0e36\u0e48\u0e07\u0e02\u0e2d\u0e07\u0e15\u0e32\u0e23\u0e32\u0e07 Customers<\/strong> \u0e17\u0e35\u0e48\u0e40\u0e01\u0e47\u0e1a\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e25\u0e39\u0e01\u0e04\u0e49\u0e32\u0e43\u0e19\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
CustomerID<\/th>\r\nCustomerName<\/th>\r\nContactName<\/th>\r\nAddress<\/th>\r\nCity<\/th>\r\nPostalCode<\/th>\r\nCountry<\/th>\r\n<\/tr>\r\n
1<\/td>Alfreds Futterkiste<\/td>Maria Anders<\/td>Obere Str. 57<\/td>Berlin<\/td>12209<\/td>Germany<\/td>\r\n<\/tr>\r\n
2<\/td>Ana Trujillo Emparedados y helados<\/td>Ana Trujillo<\/td>Avda. de la Constituci\u00f3n 2222<\/td>M\u00e9xico D.F.<\/td>05021<\/td>Mexico<\/td>\r\n<\/tr>\r\n
3<\/td>Antonio Moreno Taquer\u00eda<\/td>Antonio Moreno<\/td>Mataderos 2312<\/td>M\u00e9xico D.F.<\/td>05023<\/td>Mexico<\/td>\r\n<\/tr>\r\n
4<\/td>Around the Horn<\/td>Thomas Hardy<\/td>120 Hanover Sq.<\/td>London<\/td>WA1 1DP<\/td>UK<\/td>\r\n<\/tr>\r\n
5<\/td>Berglunds snabbk\u00f6p<\/td>Christina Berglund<\/td>Berguvsv\u00e4gen 8<\/td>Lule\u00e5<\/td>S-958 22<\/td>Sweden<\/td>\r\n<\/tr>\r\n<\/table>\r\n<\/div>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

\u0e14\u0e39\u0e15\u0e32\u0e23\u0e32\u0e07 Customers \u0e41\u0e1a\u0e1a\u0e40\u0e15\u0e47\u0e21<\/a><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t\t\t\t\t\t

\u0e15\u0e32\u0e23\u0e32\u0e07\u0e19\u0e35\u0e49\u0e21\u0e35 7 \u0e04\u0e2d\u0e25\u0e31\u0e21\u0e19\u0e4c (Columns) \u0e44\u0e14\u0e49\u0e41\u0e01\u0e48
CustomerID<\/code>, CustomerName<\/code>, ContactName<\/code>, Address<\/code>, City<\/code>, PostalCode<\/code>, \u0e41\u0e25\u0e30 Country<\/code><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t

\u0e04\u0e33\u0e2a\u0e31\u0e48\u0e07 WHERE \u0e43\u0e19 SQL<\/h2>\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

WHERE<\/strong> \u0e43\u0e0a\u0e49\u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a \u0e01\u0e23\u0e2d\u0e07\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 (Filter Records)<\/strong>
\u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e43\u0e2b\u0e49\u0e44\u0e14\u0e49\u0e40\u0e09\u0e1e\u0e32\u0e30\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e35\u0e48 \u0e15\u0e23\u0e07\u0e15\u0e32\u0e21\u0e40\u0e07\u0e37\u0e48\u0e2d\u0e19\u0e44\u0e02\u0e17\u0e35\u0e48\u0e01\u0e33\u0e2b\u0e19\u0e14\u0e44\u0e27\u0e49<\/strong> \u0e40\u0e17\u0e48\u0e32\u0e19\u0e31\u0e49\u0e19<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t\t\t\t\t\t\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07 \u0e40\u0e25\u0e37\u0e2d\u0e01\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e25\u0e39\u0e01\u0e04\u0e49\u0e32\u0e17\u0e31\u0e49\u0e07\u0e2b\u0e21\u0e14\u0e17\u0e35\u0e48\u0e2d\u0e22\u0e39\u0e48\u0e43\u0e19\u0e1b\u0e23\u0e30\u0e40\u0e17\u0e28\u0e40\u0e21\u0e47\u0e01\u0e0b\u0e34\u0e42\u0e01:\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\n\t\t\t\t\tSELECT * FROM Customers\r\nWHERE Country = 'Mexico';\r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7452b00 elementor-widget elementor-widget-button\" data-id=\"7452b00\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/kb.hostatom.com\/lesson\/sql\/trysql.php?trystatement=select_where\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-icon\">\n\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-external-link-alt\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M432,320H400a16,16,0,0,0-16,16V448H64V128H208a16,16,0,0,0,16-16V80a16,16,0,0,0-16-16H48A48,48,0,0,0,0,112V464a48,48,0,0,0,48,48H400a48,48,0,0,0,48-48V336A16,16,0,0,0,432,320ZM488,0h-128c-21.37,0-32.05,25.91-17,41l35.73,35.73L135,320.37a24,24,0,0,0,0,34L157.67,377a24,24,0,0,0,34,0L435.28,133.32,471,169c15,15,41,4.5,41-17V24A24,24,0,0,0,488,0Z\"><\/path><\/svg>\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">\u0e14\u0e39\u0e1c\u0e25\u0e25\u0e31\u0e1e\u0e18\u0e4c<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-02cd327 elementor-widget elementor-widget-text-editor\" data-id=\"02cd327\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>\u0e04\u0e33\u0e2a\u0e31\u0e48\u0e07\u0e19\u0e35\u0e49\u0e08\u0e30\u0e14\u0e36\u0e07\u0e40\u0e09\u0e1e\u0e32\u0e30\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e35\u0e48\u0e2d\u0e22\u0e39\u0e48\u0e43\u0e19\u0e04\u0e2d\u0e25\u0e31\u0e21\u0e19\u0e4c <strong>Country<\/strong> <br \/>\u0e41\u0e25\u0e30\u0e21\u0e35\u0e04\u0e48\u0e32\u0e15\u0e23\u0e07\u0e01\u0e31\u0e1a <code>'Mexico'<\/code> \u0e40\u0e17\u0e48\u0e32\u0e19\u0e31\u0e49\u0e19<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b223928 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"b223928\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cefc1fd elementor-widget elementor-widget-heading\" data-id=\"cefc1fd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">\u0e23\u0e39\u0e1b\u0e41\u0e1a\u0e1a\u0e04\u0e33\u0e2a\u0e31\u0e48\u0e07 (Syntax)<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a94c699 elementor-widget elementor-widget-code-highlight\" data-id=\"a94c699\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-sql line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-sql\">\n\t\t\t\t\t<xmp>SELECT column1, column2, ...\r\nFROM table_name\r\nWHERE condition;\r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-324ebd2 elementor-widget elementor-widget-text-editor\" data-id=\"324ebd2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u0e2d\u0e18\u0e34\u0e1a\u0e32\u0e22 :<\/strong> <br \/>\u0e04\u0e33\u0e2a\u0e31\u0e48\u0e07 <code>WHERE<\/code> \u0e44\u0e21\u0e48\u0e44\u0e14\u0e49\u0e43\u0e0a\u0e49\u0e40\u0e09\u0e1e\u0e32\u0e30\u0e01\u0e31\u0e1a <code>SELECT<\/code> \u0e40\u0e17\u0e48\u0e32\u0e19\u0e31\u0e49\u0e19 <br \/>\u0e41\u0e15\u0e48\u0e22\u0e31\u0e07\u0e2a\u0e32\u0e21\u0e32\u0e23\u0e16\u0e43\u0e0a\u0e49\u0e23\u0e48\u0e27\u0e21\u0e01\u0e31\u0e1a\u0e04\u0e33\u0e2a\u0e31\u0e48\u0e07\u0e2d\u0e37\u0e48\u0e19 \u0e46 \u0e44\u0e14\u0e49 \u0e40\u0e0a\u0e48\u0e19 <code>UPDATE<\/code>, <code>DELETE<\/code> \u0e41\u0e25\u0e30 <code>INSERT<\/code> \u0e40\u0e1b\u0e47\u0e19\u0e15\u0e49\u0e19<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7876d8f elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"7876d8f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-737db7e elementor-widget elementor-widget-heading\" data-id=\"737db7e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">\u0e02\u0e49\u0e2d\u0e04\u0e27\u0e32\u0e21 (Text Fields) vs. \u0e15\u0e31\u0e27\u0e40\u0e25\u0e02 (Numeric Fields)<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e1191b2 elementor-widget elementor-widget-text-editor\" data-id=\"e1191b2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p>\u0e04\u0e48\u0e32\u0e02\u0e49\u0e2d\u0e04\u0e27\u0e32\u0e21 (Text Values) \u0e15\u0e49\u0e2d\u0e07\u0e2d\u0e22\u0e39\u0e48\u0e43\u0e19 <strong>\u0e40\u0e04\u0e23\u0e37\u0e48\u0e2d\u0e07\u0e2b\u0e21\u0e32\u0e22\u0e2d\u0e31\u0e0d\u0e1b\u0e23\u0e30\u0e01\u0e32\u0e28\u0e40\u0e14\u0e35\u0e48\u0e22\u0e27<\/strong> <code>' '<\/code> <br \/>(\u0e2b\u0e23\u0e37\u0e2d\u0e40\u0e04\u0e23\u0e37\u0e48\u0e2d\u0e07\u0e2b\u0e21\u0e32\u0e22\u0e04\u0e39\u0e48 <code>\" \"<\/code> \u0e01\u0e47\u0e44\u0e14\u0e49\u0e43\u0e19\u0e1a\u0e32\u0e07\u0e23\u0e30\u0e1a\u0e1a\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25) <br \/>\u0e2a\u0e48\u0e27\u0e19\u0e04\u0e48\u0e32\u0e15\u0e31\u0e27\u0e40\u0e25\u0e02 (Numeric Values) <strong>\u0e44\u0e21\u0e48\u0e15\u0e49\u0e2d\u0e07\u0e43\u0e2a\u0e48\u0e40\u0e04\u0e23\u0e37\u0e48\u0e2d\u0e07\u0e2b\u0e21\u0e32\u0e22\u0e2d\u0e31\u0e0d\u0e1b\u0e23\u0e30\u0e01\u0e32\u0e28<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0309951 elementor-widget elementor-widget-code-highlight\" data-id=\"0309951\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-sql line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-sql\">\n\t\t\t\t\t<xmp>SELECT * FROM Customers\r\nWHERE CustomerID = 1;\r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-476aae6 elementor-widget elementor-widget-button\" data-id=\"476aae6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/kb.hostatom.com\/lesson\/sql\/trysql.php?trystatement=select_where_number\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-icon\">\n\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-external-link-alt\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M432,320H400a16,16,0,0,0-16,16V448H64V128H208a16,16,0,0,0,16-16V80a16,16,0,0,0-16-16H48A48,48,0,0,0,0,112V464a48,48,0,0,0,48,48H400a48,48,0,0,0,48-48V336A16,16,0,0,0,432,320ZM488,0h-128c-21.37,0-32.05,25.91-17,41l35.73,35.73L135,320.37a24,24,0,0,0,0,34L157.67,377a24,24,0,0,0,34,0L435.28,133.32,471,169c15,15,41,4.5,41-17V24A24,24,0,0,0,488,0Z\"><\/path><\/svg>\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">\u0e14\u0e39\u0e1c\u0e25\u0e25\u0e31\u0e1e\u0e18\u0e4c<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1493b8f elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"1493b8f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ee7a21b elementor-widget elementor-widget-heading\" data-id=\"ee7a21b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">\u0e15\u0e31\u0e27\u0e14\u0e33\u0e40\u0e19\u0e34\u0e19\u0e01\u0e32\u0e23 (Operators) \u0e17\u0e35\u0e48\u0e43\u0e0a\u0e49\u0e43\u0e19 WHERE Clause<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-22bc5d6 elementor-widget elementor-widget-text-editor\" data-id=\"22bc5d6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t\u0e04\u0e38\u0e13\u0e2a\u0e32\u0e21\u0e32\u0e23\u0e16\u0e43\u0e0a\u0e49 \u0e15\u0e31\u0e27\u0e14\u0e33\u0e40\u0e19\u0e34\u0e19\u0e01\u0e32\u0e23 (Operators) \u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e2a\u0e23\u0e49\u0e32\u0e07\u0e40\u0e07\u0e37\u0e48\u0e2d\u0e19\u0e44\u0e02\u0e17\u0e35\u0e48\u0e22\u0e37\u0e14\u0e2b\u0e22\u0e38\u0e48\u0e19\u0e43\u0e19\u0e01\u0e32\u0e23\u0e04\u0e49\u0e19\u0e2b\u0e32\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e44\u0e14\u0e49\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2cf634a elementor-widget elementor-widget-text-editor\" data-id=\"2cf634a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07 <\/strong>\u0e40\u0e25\u0e37\u0e2d\u0e01\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e25\u0e39\u0e01\u0e04\u0e49\u0e32\u0e17\u0e31\u0e49\u0e07\u0e2b\u0e21\u0e14\u0e17\u0e35\u0e48\u0e21\u0e35 CustomerID \u0e21\u0e32\u0e01\u0e01\u0e27\u0e48\u0e32 80<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-46ec56d elementor-widget elementor-widget-code-highlight\" data-id=\"46ec56d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-sql line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-sql\">\n\t\t\t\t\t<xmp>SELECT * FROM Customers\r\nWHERE CustomerID > 80;\r\n<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6b72471 elementor-widget elementor-widget-button\" data-id=\"6b72471\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm\" href=\"https:\/\/kb.hostatom.com\/lesson\/sql\/trysql.php?trystatement=select_where_gt\" target=\"_blank\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-icon\">\n\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-external-link-alt\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M432,320H400a16,16,0,0,0-16,16V448H64V128H208a16,16,0,0,0,16-16V80a16,16,0,0,0-16-16H48A48,48,0,0,0,0,112V464a48,48,0,0,0,48,48H400a48,48,0,0,0,48-48V336A16,16,0,0,0,432,320ZM488,0h-128c-21.37,0-32.05,25.91-17,41l35.73,35.73L135,320.37a24,24,0,0,0,0,34L157.67,377a24,24,0,0,0,34,0L435.28,133.32,471,169c15,15,41,4.5,41-17V24A24,24,0,0,0,488,0Z\"><\/path><\/svg>\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">\u0e14\u0e39\u0e1c\u0e25\u0e25\u0e31\u0e1e\u0e18\u0e4c<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-23047a6 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"23047a6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bfce361 elementor-widget elementor-widget-heading\" data-id=\"bfce361\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">\u0e15\u0e32\u0e23\u0e32\u0e07\u0e15\u0e31\u0e27\u0e14\u0e33\u0e40\u0e19\u0e34\u0e19\u0e01\u0e32\u0e23\u0e17\u0e35\u0e48\u0e43\u0e0a\u0e49\u0e44\u0e14\u0e49\u0e43\u0e19 WHERE Clause<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-239ba00 elementor-widget elementor-widget-html\" data-id=\"239ba00\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t\t<div class=\"ls-tbl-wrap\">\r\n<table class=\"ls-tbl\">\r\n<tr><th>Operator<\/th><th>\u0e04\u0e33\u0e2d\u0e18\u0e34\u0e1a\u0e32\u0e22<\/th><th>\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07<\/th><\/tr>\r\n<tr><td>=<\/td><td>\u0e40\u0e17\u0e48\u0e32\u0e01\u0e31\u0e1a<\/td><td><a href=\"https:\/\/kb.hostatom.com\/lesson\/sql\/trysql.php?trystatement=op_equal_to\" target=\"_blank\" class=\"demo-btn\">\u0e25\u0e2d\u0e07\u0e14\u0e39\u0e2a\u0e34<\/a><\/td><\/tr>\r\n<tr><td>&gt;<\/td><td>\u0e21\u0e32\u0e01\u0e01\u0e27\u0e48\u0e32<\/td><td><a href=\"https:\/\/kb.hostatom.com\/lesson\/sql\/trysql.php?trystatement=op_greater_than\" target=\"_blank\" class=\"demo-btn\">\u0e25\u0e2d\u0e07\u0e14\u0e39\u0e2a\u0e34<\/a><\/td><\/tr>\r\n<tr><td>&lt;<\/td><td>\u0e19\u0e49\u0e2d\u0e22\u0e01\u0e27\u0e48\u0e32<\/td><td><a href=\"https:\/\/kb.hostatom.com\/lesson\/sql\/trysql.php?trystatement=op_less_than\" target=\"_blank\" class=\"demo-btn\">\u0e25\u0e2d\u0e07\u0e14\u0e39\u0e2a\u0e34<\/a><\/td><\/tr>\r\n<tr><td>&gt;=<\/td><td>\u0e21\u0e32\u0e01\u0e01\u0e27\u0e48\u0e32\u0e2b\u0e23\u0e37\u0e2d\u0e40\u0e17\u0e48\u0e32\u0e01\u0e31\u0e1a<\/td><td><a href=\"https:\/\/kb.hostatom.com\/lesson\/sql\/trysql.php?trystatement=op_greater_than2\" target=\"_blank\" class=\"demo-btn\">\u0e25\u0e2d\u0e07\u0e14\u0e39\u0e2a\u0e34<\/a><\/td><\/tr>\r\n<tr><td>&lt;=<\/td><td>\u0e19\u0e49\u0e2d\u0e22\u0e01\u0e27\u0e48\u0e32\u0e2b\u0e23\u0e37\u0e2d\u0e40\u0e17\u0e48\u0e32\u0e01\u0e31\u0e1a<\/td><td><a href=\"https:\/\/kb.hostatom.com\/lesson\/sql\/trysql.php?trystatement=op_less_than2\" target=\"_blank\" class=\"demo-btn\">\u0e25\u0e2d\u0e07\u0e14\u0e39\u0e2a\u0e34<\/a><\/td><\/tr>\r\n<tr><td>&lt;&gt;<\/td><td>\u0e44\u0e21\u0e48\u0e40\u0e17\u0e48\u0e32\u0e01\u0e31\u0e1a <small>(\u0e1a\u0e32\u0e07\u0e23\u0e30\u0e1a\u0e1a\u0e43\u0e0a\u0e49 != \u0e41\u0e17\u0e19)<\/small><\/td><td><a href=\"https:\/\/kb.hostatom.com\/lesson\/sql\/trysql.php?trystatement=op_not_equal_to\" target=\"_blank\" class=\"demo-btn\">\u0e25\u0e2d\u0e07\u0e14\u0e39\u0e2a\u0e34<\/a><\/td><\/tr>\r\n<tr><td>BETWEEN<\/td><td>\u0e2d\u0e22\u0e39\u0e48\u0e23\u0e30\u0e2b\u0e27\u0e48\u0e32\u0e07\u0e04\u0e48\u0e32\u0e17\u0e35\u0e48\u0e01\u0e33\u0e2b\u0e19\u0e14<\/td><td><a href=\"https:\/\/kb.hostatom.com\/lesson\/sql\/trysql.php?trystatement=op_between\" target=\"_blank\" class=\"demo-btn\">\u0e25\u0e2d\u0e07\u0e14\u0e39\u0e2a\u0e34<\/a><\/td><\/tr>\r\n<tr><td>LIKE<\/td><td>\u0e04\u0e49\u0e19\u0e2b\u0e32\u0e04\u0e48\u0e32\u0e17\u0e35\u0e48\u0e15\u0e23\u0e07\u0e01\u0e31\u0e1a\u0e23\u0e39\u0e1b\u0e41\u0e1a\u0e1a (Pattern)<\/td><td><a href=\"https:\/\/kb.hostatom.com\/lesson\/sql\/trysql.php?trystatement=op_like\" target=\"_blank\" class=\"demo-btn\">\u0e25\u0e2d\u0e07\u0e14\u0e39\u0e2a\u0e34<\/a><\/td><\/tr>\r\n<tr><td>IN<\/td><td>\u0e23\u0e30\u0e1a\u0e38\u0e04\u0e48\u0e32\u0e2b\u0e25\u0e32\u0e22\u0e04\u0e48\u0e32\u0e17\u0e35\u0e48\u0e40\u0e1b\u0e47\u0e19\u0e44\u0e1b\u0e44\u0e14\u0e49<\/td><td><a href=\"https:\/\/kb.hostatom.com\/lesson\/sql\/trysql.php?trystatement=op_in\" target=\"_blank\" class=\"demo-btn\">\u0e25\u0e2d\u0e07\u0e14\u0e39\u0e2a\u0e34<\/a><\/td><\/tr>\r\n<\/table>\r\n<\/div>\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07 \u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07 \u0e15\u0e32\u0e23\u0e32\u0e07 Customers \u0e17\u0e35\u0e48\u0e43\u0e0a\u0e49\u0e43\u0e19\u0e01\u0e32\u0e23\u0e2d\u0e18\u0e34\u0e1a\u0e32\u0e22: \u0e01\u0e48\u0e2d\u0e19\u0e08\u0e30\u0e40\u0e23\u0e35\u0e22\u0e19\u0e23\u0e39\u0e49\u0e01\u0e32\u0e23\u0e43\u0e0a\u0e49\u0e04\u0e33\u0e2a\u0e31\u0e48\u0e07 WHERE \u0e21\u0e32\u0e14\u0e39\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e15\u0e32\u0e23\u0e32\u0e07\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e35\u0e48\u0e08\u0e30\u0e43\u0e0a\u0e49\u0e01\u0e31\u0e19\u0e01\u0e48\u0e2d\u0e19 \u0e19\u0e35\u0e48\u0e04\u0e37\u0e2d\u0e2a\u0e48\u0e27\u0e19\u0e2b\u0e19\u0e36\u0e48\u0e07\u0e02\u0e2d\u0e07\u0e15\u0e32\u0e23\u0e32\u0e07 Customers \u0e17\u0e35\u0e48\u0e40\u0e01\u0e47\u0e1a\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e25\u0e39\u0e01\u0e04\u0e49\u0e32\u0e43\u0e19\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 CustomerID CustomerName ContactName Address City PostalCode Country 1 Alfreds Futterkiste Maria Anders Obere Str. 57 Berlin 12209 Germany 2 Ana Trujillo Emparedados y helados Ana Trujillo Avda. de la Constituci\u00f3n 2222 M\u00e9xico D.F. 05021 Mexico 3 Antonio Moreno Taquer\u00eda Antonio Moreno Mataderos 2312 M\u00e9xico [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-27217","post","type-post","status-publish","format-standard","hentry","category-sql"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/kb.hostatom.com\/lesson\/wp-json\/wp\/v2\/posts\/27217","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kb.hostatom.com\/lesson\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.hostatom.com\/lesson\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.hostatom.com\/lesson\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.hostatom.com\/lesson\/wp-json\/wp\/v2\/comments?post=27217"}],"version-history":[{"count":0,"href":"https:\/\/kb.hostatom.com\/lesson\/wp-json\/wp\/v2\/posts\/27217\/revisions"}],"wp:attachment":[{"href":"https:\/\/kb.hostatom.com\/lesson\/wp-json\/wp\/v2\/media?parent=27217"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.hostatom.com\/lesson\/wp-json\/wp\/v2\/categories?post=27217"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.hostatom.com\/lesson\/wp-json\/wp\/v2\/tags?post=27217"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}