SyntaxThe syntax for the IN condition in SQL is: expression IN (value1, value2. Valuen);OR expression IN (subquery); Parameters or Arguments expression This is a value to test. Value1, value2., aluen These are the values to test against expression. If any of these values matches expression, then the IN condition will evaluate to true. Subquery This is a whose result set will be tested against expression. If any of these values matches expression, then the IN condition will evaluate to true. Supplieridsuppliernamecitystate100MicrosoftRedmondWashington200GoogleMountain ViewCalifornia300OracleRedwood CityCalifornia400Kimberly-ClarkIrvingTexas500Tyson FoodsSpringdaleArkansas600SC JohnsonRacineWisconsin700Dole Food CompanyWestlake VillageCalifornia800Flowers FoodsThomasvilleGeorgia900Electronic ArtsRedwood CityCaliforniaEnter the following SQL statement: SELECT.FROM suppliersWHERE suppliername IN ('Microsoft', 'Oracle', 'Flowers Foods');There will be 3 records selected.
These are the results that you should see. Supplieridsuppliernamecitystate100MicrosoftRedmondWashington300OracleRedwood CityCalifornia800Flowers FoodsThomasvilleGeorgiaThis example would return all rows from the suppliers table where the suppliername is either Microsoft, Oracle or Flowers Foods. Because the. is used in the select, all fields from the suppliers table would appear in the result set.It is equivalent to the following SQL statement: SELECT.FROM suppliersWHERE suppliername = 'Microsoft'OR suppliername = 'Oracle'OR suppliername = 'Flowers Foods';As you can see, using the IN condition makes the statement easier to read and more efficient than using multiple OR conditions. Productidproductnamecategoryid3Orange504Apple506Sliced Ham257KleenexNULLThis example would return all rows from the products table where the productname is not Pear, Banana or Bread. Sometimes, it is more efficient to list the values that you do not want, as opposed to the values that you do want.It is equivalent to the following SQL statement: SELECT.FROM productsWHERE productname 'Pear'AND productname 'Banana'AND productname 'Bread';As you can see, the equivalent statement is written using AND conditions instead of OR conditions because the IN condition is negated.
Update Query In Node Js Mongodb
The UPDATE statement in SQL is used to update the data of an existing table in database. We can update single columns as well as multiple columns using UPDATE statement as per our requirement.Basic Syntax UPDATE tablename SET column1 = value1, column2 = value2.WHERE condition;tablename: name of the tablecolumn1: name of first, second, third column.value1: new value for first, second, third column.condition: condition to select the rows for which thevalues of columns needs to be updated.NOTE: In the above query the SET statement is used to set new values to the particular column and the WHERE clause is used to select the rows for which the columns are needed to be updated. If we have not used the WHERE clause then the columns in all the rows will be updated.