MySQL Where Clasuse \u0915\u093e \u0909\u092a\u092f\u094b\u0917 SELECT \u0915\u0947 \u0938\u093e\u0925 \u0938\u093e\u0925 \u0906\u092a UPADTE \u0914\u0930 DELETE \u0915\u0947 \u0938\u093e\u0925 \u092d\u0940 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 \u091c\u092c \u092d\u0940 \u0906\u092a\u0915\u094b \u0915\u094b\u0908 \u092d\u0940 Operation Selected Rows \u092a\u0930 \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0924\u092c \u0939\u092e Where \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0906\u0907\u090f \u0939\u092e \u0938\u092e\u091d\u0924\u0947 \u0939\u0948 \u0915\u0940 \u0939\u092e Where \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u0924\u0928\u0947 \u0924\u0930\u0939 \u0938\u0947 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n
<\/p>\n\n\n\n
\u091c\u092c \u092d\u0940 \u0939\u092e\u0947 \u0926\u094b Table \u0915\u094b Link \u0915\u0930 \u0921\u093e\u091f\u093e \u0932\u093e\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0924\u092c \u0939\u092e = Equal Operator \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0926\u094b Table \u0915\u0947 \u092c\u0940\u091a Linking \u0915\u0930 Data \u0932\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n
SELECT * \nFROM MyTable1 a, MyTable2 b\nWHERE a.id = b.id<\/code><\/pre>\n\n\n\n
\n\n\n\nUse Where with Condition Operator ( =, <, >, <=, >=, <> )<\/h2>\n\n\n\n
\u091c\u092c \u092d\u0940 \u0939\u092e\u0947 \u0915\u093f\u0938\u0940 Column \u092a\u0930 \u0915\u094b\u0908 Specific Condition \u0932\u0917\u093e\u0928\u093e \u0939\u094b \u0924\u092c \u0939\u092e Conditional Operator \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 Condition \u0932\u0917\u093e \u0938\u0915\u0924\u0947 \u0939\u0948 \u0964 <\/p>\n\n\n\n
SELECT * FROM MyTable1 WHERE id = 500;<\/code><\/pre>\n\n\n\n\u0909\u092a\u0930\u094b\u0915\u094d\u0924 Example \u092e\u0947 \u0906\u092a\u0928\u0947 \u0926\u0947\u0916\u093e \u0915\u0940 \u0939\u092e\u0928\u0947 MyTable \u092e\u0947 \u0938\u0947 \u091c\u093f\u0938 Row \u092a\u0930 id column \u0915\u0940 value 500 \u0939\u0948\u0902 \u0935\u0939\u0940 record show \u0939\u094b\u0902\u0917\u0947\u0964 \u0907\u0938 \u0905\u0928\u0941\u0938\u093e\u0930 \u0906\u092a \u0928\u093f\u092e\u094d\u0928 \u0924\u0930\u0939 \u0938\u0947 \u092d\u0940 SQL Query \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948 \u0964 <\/p>\n\n\n\n
SELECT * FROM MyTable1 WHERE id < 500; \/\/ Less than 500\nSELECT * FROM MyTable1 WHERE id > 500; \/\/ Greater than 500\nSELECT * FROM MyTable1 WHERE id <= 500; \/\/ Less than or Equal 500\nSELECT * FROM MyTable1 WHERE id >= 500; \/\/ Greater than or Equal 500\nSELECT * FROM MyTable1 WHERE id <> 500; \/\/ Not Equal 500<\/code><\/pre>\n\n\n\n<\/p>\n\n\n\n
Video \u0915\u0947 \u092e\u093e\u0927\u094d\u092f\u092e \u0938\u0947 \u0938\u092e\u091d\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947 \u0964 <\/a><\/p>\n\n\n\n
\n\n\n\nUse Where with LIKE Operator<\/h2>\n\n\n\n
\u091c\u092c \u0939\u092e\u0947 \u0915\u093f\u0938\u0940 String Column \u092a\u0930 Exact Value \u0915\u0947 \u0938\u094d\u0925\u093e\u0928 \u092a\u0930 \u0915\u0941\u091b Character \u0938\u0947 Searching \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u092c \u0939\u092e LIKE \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n
like \u0915\u0947 \u0938\u093e\u0925 \u0939\u092e _ Underscore \u0914\u0930 % Percentage \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u092d\u0940 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n
- _ Underscore :<\/strong> \u091c\u092c \u092d\u0940 \u0939\u092e\u0947 \u090f\u0915 Character \u0938\u0947 \u0938\u0902\u092c\u0902\u0927\u093f\u0924 \u0915\u094b\u0908 Condition \u0932\u093f\u0916\u0928\u093e \u0939\u094b \u0924\u092c \u0939\u0948\u0902 _ Underscore \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li>
- % Percentage :<\/strong> \u091c\u092c \u092d\u0940 \u0939\u092e\u0947 \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 Character \u0938\u0947 \u0938\u0902\u092c\u0902\u0927\u093f\u0924 \u0915\u094b\u0908 Condition \u0932\u093f\u0916\u0928\u093e \u0939\u094b \u0924\u092c \u0939\u0948\u0902 % Percentage \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li><\/ul>\n\n\n\n
Example 1:<\/strong> \u0939\u092e\u0947 Student table \u0938\u0947 A \u0928\u093e\u092e \u0938\u0947 \u0936\u0941\u0930\u0942 \u0939\u094b\u0928\u0947 \u0935\u093e\u0932\u0947 Student \u0915\u0940 \u0932\u093f\u0938\u094d\u091f \u0926\u0947\u0916\u0928\u093e \u0939\u094b \u0924\u094b <\/p>\n\n\n\nSELECT * FROM STUDENT WHERE STUD_NAME LIKE 'A%';<\/code><\/pre>\n\n\n\n<\/p>\n\n\n\n
Example 2 : <\/strong>\u0939\u092e\u0947 Student table \u0938\u0947 A \u0938\u0947 \u0905\u0902\u0924 \u0939\u094b\u0928\u0947 \u0935\u093e\u0932\u0947 \u0928\u093e\u092e \u0915\u0947 Student \u0915\u0940 \u0932\u093f\u0938\u094d\u091f \u0926\u0947\u0916\u0928\u093e \u0939\u094b \u0924\u094b <\/p>\n\n\n\nSELECT * FROM STUDENT WHERE STUD_NAME LIKE '%A';<\/code><\/pre>\n\n\n\nExample 3 : <\/strong>\u092f\u0926\u093f \u0939\u092e \u0926\u0947\u0916\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0915\u0940 Student \u0915\u0947 \u0928\u093e\u092e \u0915\u093e \u092a\u0939\u0932\u093e \u0905\u0915\u094d\u0937\u0930 \u0915\u0941\u091b \u092d\u0940 \u0939\u094b \u0932\u0947\u0915\u093f\u0928 \u0926\u0942\u0938\u0930\u093e \u0905\u0915\u094d\u0937\u0930 A \u0939\u0940 \u0939\u094b\u0928\u093e \u091a\u093e\u0939\u093f\u090f \u091f\u0947\u092c\u0932 \u0939\u092e \u0907\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 \u0938\u0947 \u0932\u093f\u0916\u0947\u0902\u0917\u0947 \u0964 <\/p>\n\n\n\nSELECT * FROM STUDENT WHERE STUD_NAME LIKE '_A%';<\/code><\/pre>\n\n\n\n\u0907\u0938 \u0924\u0930\u0939 \u0938\u0947 \u0906\u092a \u0915\u094b\u0908 \u092d\u0940 Combination \u092c\u0928\u093e \u0915\u0930 like \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n
\n\n\n\nUse Where with BETWEEN Operator<\/h2>\n\n\n\n
\u091c\u092c \u0939\u092e\u0947 \u0915\u093f\u0938\u0940 \u0930\u0947\u0902\u091c \u0915\u0947 \u092c\u0940\u091a \u0915\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 \u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 \u0921\u093e\u091f\u093e \u0926\u0947\u0916\u0928\u093e \u0939\u094b \u0924\u092c \u0939\u092e Between Operator \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n
SELECT * FROM STUDENT WHERE fee BETWEEN 1000 AND 5000;<\/code><\/pre>\n\n\n\n\u0909\u092a\u0930\u094b\u0915\u094d\u0924 Example \u092e\u0947 student \u091f\u0947\u092c\u0932 \u092e\u0947 \u091c\u093f\u0928 Studens \u0915\u0940 fee 1000 \u0938\u0947 5000 \u0915\u0947 \u092c\u0940\u091a \u0939\u094b\u0917\u0940 \u0935\u0939 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u0940 <\/p>\n\n\n\n
\n\n\n\nUse Where with IN Operator<\/h2>\n\n\n\n
\u091c\u092c \u0939\u092e\u0947 \u0915\u0947 \u0939\u0940 \u0915\u0949\u0932\u092e \u092e\u0947 \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 \u0935\u0948\u0932\u094d\u092f\u0942 \u0915\u093e Data \u0932\u093e\u0928\u093e \u0939\u0948\u0902 \u0924\u092c \u0939\u092e IN \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n
SELECT * FROM STUDENT WHERE id in (1,9,10)<\/code><\/pre>\n\n\n\n\u0909\u092a\u0930\u094b\u0915\u094d\u0924 Example \u092e\u0947 \u0939\u092e\u0947 Student \u0915\u0940 table \u092e\u0947 \u0938\u0947 id \u0935\u093e\u0932\u0947 column \u092e\u0947 \u091c\u093f\u0938\u092e\u0947 1 , 9 , 10 \u0935\u0948\u0932\u094d\u092f\u0942 \u0939\u094b\u0917\u0940 \u0935\u0939 \u0930\u093f\u0915\u093e\u0930\u094d\u0921 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0928\u0947 \u0932\u0917\u0947\u0902\u0917\u0947 \u0964 <\/p>\n\n\n\n
NOT IN Example<\/strong><\/h3>\n\n\n\n\u0928\u093f\u092e\u094d\u0928 Example \u092e\u0947 1,9,10 \u0915\u0947 \u0905\u0932\u093e\u0935\u093e \u0938\u092d\u0940 Record \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0928\u0947 <\/p>\n\n\n\n
SELECT * FROM STUDENT WHERE id not in (1,9,10)<\/code><\/pre>\n\n\n\n<\/p>\n\n\n\n
\n\n\n\nUse Where with Sub Query<\/h2>\n\n\n\n
\u0906\u092a IN Operator \u092e\u0947 Sub Query \u092d\u0940 pass \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n
SELECT * FROM STUDENT WHERE id in (select id from OtherTable)<\/code><\/pre>\n\n\n\n \u0909\u092a\u0930\u094b\u0915\u094d\u0924 Example \u092e\u0947 \u0939\u092e\u0928\u0947 \u0935\u0948\u0932\u094d\u092f\u0942 Direct \u0926\u0947\u0928\u0947 \u0915\u0947 \u0938\u094d\u0925\u093e\u0928 \u092a\u0930 OtherTable \u0938\u0947 \u0932\u093f\u092f\u093e \u0939\u0948\u0902 \u0907\u0938 \u0924\u0930\u0939 \u0938\u0947 \u092d\u0940 \u0906\u092a IN Operator \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n
\n\n\n\nUse Where with LOGICAL Operator (AND, OR)<\/h2>\n\n\n\n
AND\/OR : <\/strong>\u091c\u092c \u092d\u0940 \u0939\u092e\u0947 \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 Condition \u0932\u0917\u093e\u0928\u093e \u0939\u094b \u0924\u092c \u0939\u092e AND \u0914\u0930 OR \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\nSELECT * FROM STUDENT WHERE id > 5 AND fee < 5000;\nSELECT * FROM STUDENT WHERE id > 5 OR fee < 5000;<\/code><\/pre>\n\n\n\n\u092a\u0939\u0932\u0947 \u0935\u093e\u0932\u0947 Example \u092e\u0947 \u091c\u092c Record \u091c\u092c \u0939\u0940 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u093e \u091c\u092c \u0926\u094b\u0928\u094b\u0902 condition True \u0939\u094b\u0917\u0940 \u091c\u092c\u0915\u093f \u0926\u0942\u0938\u0930\u0940 \u0935\u093e\u0932\u0940 SQL \u092e\u0947 \u0926\u094b\u0928\u094b\u0902 \u092e\u0947 \u0938\u0947 \u090f\u0915 \u092d\u0940 condition true \u0939\u094b \u0917\u0908 \u0924\u094b Record \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0928\u0947 \u0932\u0917\u0947\u0902\u0917\u0947 \u0964 <\/p>\n\n\n\n
NOT : <\/strong>\u0915\u093f\u0938 \u092d\u0940 Condition \u0915\u094b Reverse \u0915\u0930\u0928\u0947 \u092e\u0947 \u092d\u0940 \u0907\u0938\u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\nSELECT * FROM STUDENT WHERE not id > 5;<\/code><\/pre>\n\n\n\n<\/p>\n\n\n\n
\n\n\n\n\u0906\u092a\u0915\u094b MySQL Where Clause Article \u0915\u0948\u0938\u093e \u0932\u0917\u093e \u0939\u092e\u0947 \u091c\u0930\u0942\u0930 \u092c\u0924\u093e\u090f \u0964 <\/p>\n\n\n\n
\u0939\u092e\u093e\u0930\u0947 \u0905\u0928\u094d\u092f \u0906\u0930\u094d\u091f\u093f\u0915\u0932<\/strong><\/h2>\n\n\n\n- MySQL Function<\/a><\/li>
- MySQL Stored Procedure<\/a><\/li>
- PHP Get \/Post Method \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>
- PHP Math Function \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>
- C \u0938\u0947 C ++ \u0938\u0940\u0916\u0947 \u0938\u0930\u0932 \u0936\u092c\u094d\u0926\u094b\u0902 \u092e\u0947\u0902<\/a><\/li>
- PHP Variable \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>
- Arduino Control Structure<\/a>\u00a0<\/li>
- Union in C<\/a><\/li>
- Declaration of Pointer in C<\/a><\/li>
- jQuery Search Filter<\/a><\/li>
- MySQL Create Table | Alter Table | Drop Table<\/a><\/li>
- API Using NODE REACT EXPRESS MYSQL SEQUELIZE (For Backend OR Server Side)<\/a><\/li>
- CPANEL In Hindi<\/a><\/li><\/ul>\n\n\n\n
<\/h2>\n","protected":false},"excerpt":{"rendered":"
MySQL Where Clasuse \u0915\u093e \u0909\u092a\u092f\u094b\u0917 SELECT \u0915\u0947 \u0938\u093e\u0925 \u0938\u093e\u0925 \u0906\u092a UPADTE \u0914\u0930 DELETE \u0915\u0947 \u0938\u093e\u0925 \u092d\u0940 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 \u091c\u092c \u092d\u0940 \u0906\u092a\u0915\u094b \u0915\u094b\u0908 \u092d\u0940 Operation Selected Rows \u092a\u0930 \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0924\u092c \u0939\u092e Where \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0906\u0907\u090f \u0939\u092e \u0938\u092e\u091d\u0924\u0947 \u0939\u0948 \u0915\u0940 \u0939\u092e Where \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u0924\u0928\u0947 \u0924\u0930\u0939 \u0938\u0947 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 […]<\/p>\n","protected":false},"author":1,"featured_media":8739,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-8587","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/07\/mysql-where-clause-new.jpg?fit=1200%2C628&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/8587","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/comments?post=8587"}],"version-history":[{"count":84,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/8587\/revisions"}],"predecessor-version":[{"id":9214,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/8587\/revisions\/9214"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/8739"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=8587"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=8587"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=8587"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}