Search in progress......

SELECT
hc.*,
IF(hc.prix>0,1,0) AS hasPrix

FROM
( habitations_criteres AS hc
, habitations AS h )

WHERE

1
AND h.id = hc.id AND (
h.téléphone LIKE '%-743-5356'
OR h.mobile LIKE '%-743-5356'
OR h.télécopieur LIKE '%-743-5356'
OR h.autre LIKE '%-743-5356'
)