do an if in the where of a select

Question

do an if in the where of a select

Navigation

#1 by (4 votes)
#2 by (3 votes)

0

How can I do an if in the where in mysql

I want to validate this

$parametro= mujer
$parametro= Hombre
$parametro= Indistinto

select * from tabla s

if field s.sexo = $parametro OR if the parameter is called No matter what the whole table brings me

mysql

asked by Carlos Enrique Gil Gil 11.06.2018 в 18:17

source

2 answers

4

It would be like this:

select * from tabla s Where (s.sexo = $parametro) Or ($parametro = 'Indistinto')

answered by 11.06.2018 в 18:45

how can I control my scroll of a Chatroom? [closed] Duplicate record with new ID and another custom field

score 3 · Accepted Answer

You must create a stored procedure to which you pass as a parameter the sex and filter the data according to that:

DROP PROCEDURE IF EXISTS obtenerData //

CREATE PROCEDURE 
  obtenerData( parametro VARCHAR(20) )
BEGIN
   IF(parametro = 'Indistinto') THEN
      -- Devuelves toda la tabla si es 'Indistinto'
      SELECT * FROM tabla 
   ELSE
      -- Sino devuelves data de acuerdo al parámetro
      SELECT * FROM tabla WHERE tabla.sexo = parametro
   ENDIF
   ;  
END 
//

DELIMITER ;

Then you call that stored procedure according to your parameter

call obtenerData('Hombre');
call obtenerData('Mujer');
call obtenerData('Indistinto');