Search
Search

Mysql select Query with multiple conditions of same column

Kani Published at Dev
28
Kani

I need MySQL select query like

select wt_id,wt_name from work_type where cat_id=1,2,5..;

Is it possible?

Saharsh Shah

You just have to use IN operator

SELECT wt_id, wt_name 
FROM work_type 
WHERE cat_id IN (1,2,5..);

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

MySQL query with multiple conditions on same column

From Dev

Mysql multiple select with multiple different where conditions in the same query

From Dev

Mysql multiple select with multiple different where conditions in the same query

From Dev

mysql query select multiple rows where column value is same

From Dev

Combining multiple where conditions in mysql SELECT query

From Dev

mysql - SELECT AND INSERT QUERY into multiple table with conditions

From Dev

SQl query Multiple select statments in the same table under different conditions

From Dev

Select the same column multiple times with MySQL

From Dev

Slow MySQL query after adding multiple OR conditions to indexed column

From Dev

multiple conditions in the same SQL query

From Dev

multiple conditions in the same SQL query

From Java

Search for multiple conditions on same column?

From Dev

run select query on multiple conditions

From Dev

Mysql select query special conditions

From Dev

Query to select multiple records from same column with CodeIgniter

From Dev

SQL - SELECT a column that compares multiple rows of the same query

From Dev

to write a select query which strictly satisfies a multiple condition on same column

From Dev

Filtering a MySQL query with multiple conditions

From Dev

Filtering a MySQL query with multiple conditions

From Dev

MYSQL - Multiple Conditions in One Query

From Dev

MYSQL Query Select which has same column and group by

From Dev

Mysql Query Select from same column specific range

From Dev

Run multiple inserts with the data of the same select query in MySQL

From Dev

Mysql select multiple query

From Dev

Select same column with different alias and different conditions

From Dev

select query from one table to check same value exist in column, mysql select query

From Dev

Multiple Select queries with multiple where conditions on MySQL

From Dev

Multiple COUNT() for multiple conditions in one query (MySQL)

From Dev

SQL select with multiple conditions on the same table

Related Related

  1. 1

    MySQL query with multiple conditions on same column

  2. 2

    Mysql multiple select with multiple different where conditions in the same query

  3. 3

    Mysql multiple select with multiple different where conditions in the same query

  4. 4

    mysql query select multiple rows where column value is same

  5. 5

    Combining multiple where conditions in mysql SELECT query

  6. 6

    mysql - SELECT AND INSERT QUERY into multiple table with conditions

  7. 7

    SQl query Multiple select statments in the same table under different conditions

  8. 8

    Select the same column multiple times with MySQL

  9. 9

    Slow MySQL query after adding multiple OR conditions to indexed column

  10. 10

    multiple conditions in the same SQL query

  11. 11

    multiple conditions in the same SQL query

  12. 12

    Search for multiple conditions on same column?

  13. 13

    run select query on multiple conditions

  14. 14

    Mysql select query special conditions

  15. 15

    Query to select multiple records from same column with CodeIgniter

  16. 16

    SQL - SELECT a column that compares multiple rows of the same query

  17. 17

    to write a select query which strictly satisfies a multiple condition on same column

  18. 18

    Filtering a MySQL query with multiple conditions

  19. 19

    Filtering a MySQL query with multiple conditions

  20. 20

    MYSQL - Multiple Conditions in One Query

  21. 21

    MYSQL Query Select which has same column and group by

  22. 22

    Mysql Query Select from same column specific range

  23. 23

    Run multiple inserts with the data of the same select query in MySQL

  24. 24

    Mysql select multiple query

  25. 25

    Select same column with different alias and different conditions

  26. 26

    select query from one table to check same value exist in column, mysql select query

  27. 27

    Multiple Select queries with multiple where conditions on MySQL

  28. 28

    Multiple COUNT() for multiple conditions in one query (MySQL)

  29. 29

    SQL select with multiple conditions on the same table

HotTag

Archive