MySQL IF ELSE Conditions

Question

I need a query to check the table with few conditions and return one result:

SELECT 

    IF(id='123' AND user='alex') FOUND -> return false ELSE -> return true
    IF(user='alex') NOT FOUND -> return false

FROM `table`

I have no idea on how to build such query in php function, when it call, result true or false will return

function check(id, user)
{
    $q = $mysqli->query("...sql query...");

    if($q->num_rows > 0){
        return true;
    }
    return false;
}

Read this first mysqltutorial.org/mysql-case-statement

HarisH Sharma
– HarisH Sharma

2017-03-10 07:35:08 +00:00
Commented Mar 10, 2017 at 7:35 — HarisH Sharma
– HarisH Sharma, Commented Mar 10, 2017 at 7:35

Tiago Peres · Accepted Answer · 2017-03-10 07:58:33Z

1

Forget about PHP code at this stage.

Think more high-level.

First thing you need to do is grab the right data to associate to a variable.

Use HeidiSQL (useful, reliable tool, open-source and entirely free to use) for testing the queries within your DB.

CASE WHEN (table.id='123' AND table.user='alex') 
       THEN 1
       ELSE 0
END AS alexexists

or the simpler:

(table.id='123' AND table.user='alex') AS alexexists

This works because TRUE is displayed as 1 in MySQL and FALSE as 0.

answered Mar 10, 2017 at 7:58

Tiago Peres

15.9k22 gold badges104 silver badges174 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vineeth Prabhakaran · Accepted Answer · 2017-03-10 08:12:02Z

1

here is also a suggestion you can also create a query like

Select (case when table.id='123' and table.user='alex' then false
            when table.id!='alex' then false
            else true End ) as  alexexists
from table;

answered Mar 10, 2017 at 8:12

Vineeth Prabhakaran

6514 gold badges12 silver badges25 bronze badges

Collectives™ on Stack Overflow

MySQL IF ELSE Conditions

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related