Yahoo Poland Wyszukiwanie w Internecie

Zaloguj się

Search results

  1. stackoverflow.com › questions › 6121630How to write MySQL query where A contains ( "a" or "b" )

    25 maj 2011 · Two options: Use the LIKE keyword, along with percent signs in the string. select * from table where field like '%a%' or field like '%b%'. (note: If your search string contains percent signs, you'll need to escape them)

  2. www.w3schools.com › mysql › mysql_whereMySQL WHERE Clause - W3Schools

    The MySQL WHERE Clause. The WHERE clause is used to filter records. It is used to extract only those records that fulfill a specified condition. WHERE Syntax. SELECT column1, column2, ... FROM table_name. WHERE condition; Note: The WHERE clause is not only used in . SELECT statements, it is also used in UPDATE, DELETE, etc.! Demo Database.

  3. stackoverflow.com › questions › 14046637sql - MySQL Multiple Where Clause - Stack Overflow

    27 gru 2012 · You need to use OR instead of AND in your query like below. $query = mysql_query("SELECT image_id FROM list WHERE (style_id = 24 AND style_value = 'red') OR (style_id = 25 AND style_value = 'big') OR (style_id = 27 AND style_value = 'round'); Try out this query. answered Oct 16, 2015 at 7:01. Ajay Gupta.

  4. www.mysqltutorial.org › mysql-basics › mysql-whereMySQL WHERE - MySQL Tutorial

    This tutorial shows you how to use MySQL WHERE clause to filter rows based on specified conditions.

  5. learnsql.com › cookbook › how-use-multiple-where-conditions-in-single-query-sqlHow to Use Multiple WHERE Conditions in a Single Query

    To filter data by multiple conditions in a WHERE clause, use the AND operator to connect the conditions. Here’s what this looks like for two conditions: WHERE condition1 AND condition2. In our example, condition1 is dept = 'Finance' and condition2 is salary > 4000.

  6. stackabuse.com › guide-to-the-where-clause-in-mysqlGuide to the WHERE Clause in MySQL - Stack Abuse

    26 kwi 2023 · The syntax of the WHERE clause is as follows: SELECT column1, column2, ... FROM table_name. WHERE condition; Here, SELECT specifies the columns you want to retrieve, FROM specifies the table you want to retrieve them from, and WHERE specifies the condition that must be met for a row to be included in the result set.

  7. www.geeksforgeeks.org › mysql-where-clauseMySQL WHERE Clause - GeeksforGeeks

    21 cze 2024 · The WHERE clause is used to specify a condition while fetching data from a single table or by joining multiple tables. Only the records that meet the specified condition are retrieved. Syntax: SELECT column1, column2, ... FROM table_name.