# MySQL 5.1 diff 5.5 -\> Err : SELECT IF( ((...)), NULL) AS alias :/

**URL:** <https://www.debian-fr.org/t/mysql-5-1-diff-5-5-err-select-if-null-as-alias/72183>\
**Category:** Programmation\
**Created:** [Décembre 31, 2016, 3:03 UTC](https://www.debian-fr.org/t/mysql-5-1-diff-5-5-err-select-if-null-as-alias/72183 "2016-12-31T03:03:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![anon36725218](https://www.debian-fr.org/letter_avatar_proxy/v4/letter/a/8e8cbc/32.png) [@anon36725218](https://www.debian-fr.org/u/anon36725218)\
**Post date:** [Décembre 31, 2016, 3:03 UTC](https://www.debian-fr.org/t/mysql-5-1-diff-5-5-err-select-if-null-as-alias/72183/1 "2016-12-31T03:03:58Z")

</div>

Bonjour à tous.

j’ai un soucis avec une requête MySQL sur la version 5.5 ☹

Avant je faisais cela :

```
//---------------------------------------------------------------------
// MySQL : 5.1.73-1
//---------
SELECT c.*, a.*,
IF(c.content_id_usr = 0, ((SELECT a.content_usr_var1 FROM zw_contents_anonymes a WHERE a.content_content_id = c.content_id_join), NULL)) AS content_usr_var1, 
IF(c.content_id_usr = 0, ((SELECT a.content_usr_var2 FROM zw_contents_anonymes a WHERE a.content_content_id = c.content_id_join), NULL)) AS content_usr_var2
FROM zw_contents c, zw_contents_anonymes a
WHERE c.content_tree_id = 100;

```

J’ai essayé çà :

```
//---------------------------------------------------------------------
// MySQL : 5.5.53-0
//---------

SELECT c.*, a.*,
IF(c.content_id_usr = 0, "pseudodNyme", NULL)) AS content_usr_var1
FROM zw_contents c, zw_contents_anonymes a
WHERE c.content_tree_id = 100;

SELECT c.*, a.*,
IF(c.content_id_usr = 0, "pseudodNyme", NULL)) AS content_usr_var1, 
FROM zw_contents c
LEFT JOIN zw_contents_anonymes a ON c.content_id_join = a.content_content_id
WHERE c.content_tree_id = 100;

SELECT c.*, a.*,
CASE WHEN c.content_id_usr = 0 THEN 'pseudodNyme' ELSE NULL END AS content_usr_var1
FROM zw_contents c
LEFT JOIN zw_contents_anonymes a ON jc.content_id_join = a.content_content_id
WHERE c.content_tree_id = 100;

```

Je recherche, je recherche…

Si vous avez une idée 🙂 En vous remerciant.

Romain

---

<div class="post-metadata">

**Author:** ![anon36725218](https://www.debian-fr.org/letter_avatar_proxy/v4/letter/a/8e8cbc/32.png) [@anon36725218](https://www.debian-fr.org/u/anon36725218)\
**Post date:** [Janvier 4, 2017, 2:54 UTC](https://www.debian-fr.org/t/mysql-5-1-diff-5-5-err-select-if-null-as-alias/72183/2 "2017-01-04T14:54:51Z")

</div>

Bon j’ai mis en PHP :

`if(substr(mysql_get_server_info(), 0, 3) >= ‘5.5’) ` mais bon ? Une idée !? quelqu’un ?

En vous remerciant 😉