Breaking News: Grepper is joining You.com. Read the official announcement!

mysql if statement in where clause

Add Answer

Weary Wryneck answered on April 15, 2021 Popularity 10/10 Helpfulness 3/10

answer mysql if statement in where clause

related mysql if

related mysql if statement

related MySQL if condition

mysql if statement in where clause

Comment

SELECT  `id` ,  `naam` 
FROM  `klanten` 
WHERE IF(`email` != '', `email`, `email2`) LIKE  '%@domain.nl%'

Popularity 10/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: if-statement mysql sql where-clause

Link to this answer
Share Copy Link

Contributed on Apr 15 2021

Weary Wryneck

0 Answers Avg Quality 2/10

Closely Related Answers

mysql if

Comment

SELECT user_display_image AS user_image,
       user_display_name AS user_name,
       invitee_phone,
       (CASE WHEN invitee_status = 1 THEN "attending"
             WHEN invitee_status = 2 THEN "unsure"
             WHEN invitee_status = 3 THEN "declined"
             WHEN invitee_status = 0 THEN "notreviwed"
       END) AS invitee_status
  FROM your_table

Popularity 10/10 Helpfulness 4/10 Language sql

Source: stackoverflow.com

Tags: mysql mysq

Link to this answer
Share Copy Link

Contributed on Oct 18 2021

Restu Wahyu Saputra

0 Answers Avg Quality 2/10

mysql if statement

Comment

-- PL/SQL
BEGIN
    IF my_val = 1 THEN [...]
    ELSE [...]
    END IF;
END;
-- In a query
SELECT CASE WHEN my_col = 1 THEN 'Ok' ELSE 'Ko' END AS my_result;

Popularity 10/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: execute

Link to this answer
Share Copy Link

Contributed on Jul 04 2021

VasteMonde

0 Answers Avg Quality 2/10

MySQL if condition

Comment

The if accept one condition, if this condition is true then the true_value will occur 
else the false_value will occur.
IF(condition, true_value, false_value)
Tips : can be to update some data

Popularity 10/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: mysql mysq

Link to this answer
Share Copy Link

Contributed on Oct 29 2022

Salaun Nolann cs22f403

0 Answers Avg Quality 2/10

mysql if statement in where clause

Contents

More Related Answers

mysql if statement in where clause

Closely Related Answers

mysql if

mysql if statement

MySQL if condition

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.