{"id":71,"date":"2017-03-22T06:22:15","date_gmt":"2017-03-22T06:22:15","guid":{"rendered":"http:\/\/abhiandroid.com\/database\/?p=71"},"modified":"2017-03-22T06:22:15","modified_gmt":"2017-03-22T06:22:15","slug":"list-of-all-operators-in-sqlite","status":"publish","type":"post","link":"https:\/\/abhiandroid.com\/database\/list-of-all-operators-in-sqlite.html","title":{"rendered":"List Of All Operators In SQLite"},"content":{"rendered":"<p>Operators are the built in reserve words which have specified meaning behind them. These operators are used with in query for some comparisons or other operations.<\/p>\n<hr \/>\n<h4><strong>Operators In SQLite:<\/strong><\/h4>\n<ul>\n<li><strong>Arithmetic<\/strong><\/li>\n<li><strong> Relational<\/strong><\/li>\n<li><strong> Logical<\/strong><\/li>\n<li><strong> Bitwise<\/strong><\/li>\n<\/ul>\n<h4><strong>ARITHMETIC <\/strong><\/h4>\n<p>Arithmetic operators are used for basic mathematical operators i.e addition(+), subtraction(-), multiplication(*),division(\/) and modulus(%).<br \/>\nLet&#8217;s consider <span style=\"color: #008000;\">A= 10 &amp; B= 5.<\/span><\/p>\n<ul>\n<li><strong>Addition :<\/strong> Add the values in either order it is defined, so\u00a0<span style=\"color: #008000;\">\u00a0A+B<\/span> will give 15.<\/li>\n<li><strong>Subtraction :<\/strong> Subtract the right side operand from left one, so<span style=\"color: #008000;\"> A-B<\/span> will give 5.<\/li>\n<li><strong>Multiplication :<\/strong> Multiply the values in either order it is defined, so<span style=\"color: #008000;\"> A*B<\/span> will give 50.<\/li>\n<li><strong>Division :<\/strong> Divide numerator by denominator, so <span style=\"color: #008000;\">A\/B<\/span> will give 2.<\/li>\n<li><strong>Modulus :<\/strong> Divide the left side operand with right side and return remainder, so<span style=\"color: #008000;\"> A%B<\/span> will give 0.<\/li>\n<\/ul>\n<h4><strong>RELATIONAL<\/strong><\/h4>\n<p>Relational operators are also the basic mathematical operators.<br \/>\nLet&#8217;s consider <span style=\"color: #008000;\">A= 10 &amp; B= 5<\/span>.<\/p>\n<ul>\n<li><strong><span style=\"color: #008000;\">\u00a0&lt;<\/span>\u00a0 \u00a0 :<\/strong>\u00a0Return true when\u00a0left operand is less than right , so <span style=\"color: #008000;\">\u00a0(A&lt;B) \u00a0<\/span>is false.<\/li>\n<li><strong><span style=\"color: #008000;\">\u00a0&lt;= \u00a0<\/span>:<\/strong> Return true when left operand is less than or equal to right , so<span style=\"color: #008000;\">\u00a0(A&lt;=B)<\/span>\u00a0is false.<\/li>\n<li><strong><span style=\"color: #008000;\">\u00a0&gt; \u00a0 \u00a0<\/span>:<\/strong> Return true when left operand is greater than right, so <span style=\"color: #008000;\">\u00a0(A&gt;B) \u00a0<\/span>is\u00a0true.<\/li>\n<li><strong><span style=\"color: #008000;\">\u00a0&gt;= \u00a0<\/span>:<\/strong>\u00a0 Return true when left operand is greater than or equal to right, so <span style=\"color: #008000;\">\u00a0(A&gt;=B) \u00a0<\/span>is true.<\/li>\n<li><strong><span style=\"color: #008000;\">\u00a0= or == \u00a0<\/span>:<\/strong>\u00a0 Return true when both operand are equal to each other, so <span style=\"color: #008000;\">(A=B)<\/span> is false.<\/li>\n<li><strong><span style=\"color: #008000;\">\u00a0!= or &lt;&gt; \u00a0<\/span>:<\/strong> Return true when both operand are not equal to each other, so <span style=\"color: #008000;\">(A=B)<\/span> is true.<\/li>\n<\/ul>\n<h4><strong>LOGICAL<\/strong><\/h4>\n<p>Here are the logical operators.<\/p>\n<ul>\n<li><strong><span style=\"color: #008000;\">\u00a0AND<\/span>\u00a0:<\/strong>\u00a0Return true when all conditions defined with AND are true, else false.<\/li>\n<li><strong><span style=\"color: #008000;\">\u00a0OR= \u00a0<\/span>:\u00a0<\/strong>Return true when any conditions defined with OR is\u00a0true, else false<\/li>\n<li><strong><span style=\"color: #008000;\">\u00a0NOT <\/span>:\u00a0<\/strong>It is negative operator, reverse the meaning of the operand.<\/li>\n<li><strong><span style=\"color: #008000;\">\u00a0BETWEEN \u00a0<\/span>:\u00a0<\/strong>The between operator returns the value defined between minimum &amp; maximum value.<\/li>\n<li><strong><span style=\"color: #008000;\">\u00a0IN\u00a0<\/span>:\u00a0<\/strong>The IN operator allow to specify multiple values with it and return rows as specified.<\/li>\n<li><strong><span style=\"color: #008000;\">\u00a0NOT IN\u00a0<\/span>:\u00a0<\/strong>It is reverse of IN operator, returns values which or not specified, user can input multiple values in it.<\/li>\n<li><strong><span style=\"color: #008000;\">\u00a0EXISTS\u00a0<\/span>:\u00a0<\/strong>This operator finds weather specified row exists.<\/li>\n<\/ul>\n<h4><strong>BITWISE<\/strong><\/h4>\n<p>Here are the bitwise operators.<\/p>\n<ul>\n<li><strong><span style=\"color: #008000;\">\u00a0&amp;<\/span>\u00a0 \u00a0:<\/strong>\u00a0Binary AND<\/li>\n<li><strong><span style=\"color: #008000;\">\u00a0| \u00a0 \u00a0<\/span>:\u00a0<\/strong>Binary OR<\/li>\n<li><strong><span style=\"color: #008000;\">\u00a0&gt;&gt; \u00a0<\/span>:\u00a0<\/strong>Binary right shift.<\/li>\n<li><strong><span style=\"color: #008000;\">\u00a0&lt;&lt; \u00a0<\/span>:\u00a0<\/strong>Binary left shift.<\/li>\n<\/ul>\n<p><span style=\"color: #008000;\"><strong>Truth Table for &#8216;&amp;&#8217; and &#8216;|&#8217;<\/strong><\/span><\/p>\n<table border=\"1\" width=\"500\">\n<tbody>\n<tr>\n<th style=\"text-align: center;\"><span style=\"color: #008000;\">A<\/span><\/th>\n<th style=\"text-align: center;\"><span style=\"color: #008000;\">B<\/span><\/th>\n<th style=\"text-align: center;\"><span style=\"color: #008000;\">A&amp;B<\/span><\/th>\n<th style=\"text-align: center;\"><span style=\"color: #008000;\">A|B<\/span><\/th>\n<\/tr>\n<tr style=\"text-align: center;\">\n<td>0<\/td>\n<td>0<\/td>\n<td>0<\/td>\n<td>0<\/td>\n<\/tr>\n<tr style=\"text-align: center;\">\n<td>0<\/td>\n<td>1<\/td>\n<td>0<\/td>\n<td>1<\/td>\n<\/tr>\n<tr style=\"text-align: center;\">\n<td>1<\/td>\n<td>0<\/td>\n<td>0<\/td>\n<td>1<\/td>\n<\/tr>\n<tr style=\"text-align: center;\">\n<td>1<\/td>\n<td>1<\/td>\n<td>1<\/td>\n<td>1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>Operators are the built in reserve words which have specified meaning behind them. These operators are used with in query for some comparisons or other operations. Operators In SQLite: Arithmetic Relational Logical Bitwise ARITHMETIC Arithmetic operators are used for basic mathematical operators i.e addition(+), subtraction(-), multiplication(*),division(\/) and modulus(%). Let&#8217;s consider A= 10 &amp; B= 5. &hellip; <a href=\"https:\/\/abhiandroid.com\/database\/list-of-all-operators-in-sqlite.html\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">List Of All Operators In SQLite<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-71","post","type-post","status-publish","format-standard","hentry","category-archive"],"acf":[],"psp_head":"<title>List Of All Operators In SQLite \u2013 Android Database Tutorial In Android Studio: Store Your Data<\/title>\r\n<meta name=\"description\" content=\"Operators are the built in reserve words which have specified meaning behind them. These operators are used with in query for some comparisons or other operations.\" \/>\r\n<meta name=\"robots\" content=\"index,follow\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/abhiandroid.com\/database\/list-of-all-operators-in-sqlite.html\" \/>\r\n","_links":{"self":[{"href":"https:\/\/abhiandroid.com\/database\/wp-json\/wp\/v2\/posts\/71","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/abhiandroid.com\/database\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/abhiandroid.com\/database\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/abhiandroid.com\/database\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/abhiandroid.com\/database\/wp-json\/wp\/v2\/comments?post=71"}],"version-history":[{"count":0,"href":"https:\/\/abhiandroid.com\/database\/wp-json\/wp\/v2\/posts\/71\/revisions"}],"wp:attachment":[{"href":"https:\/\/abhiandroid.com\/database\/wp-json\/wp\/v2\/media?parent=71"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/abhiandroid.com\/database\/wp-json\/wp\/v2\/categories?post=71"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/abhiandroid.com\/database\/wp-json\/wp\/v2\/tags?post=71"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}