MySql: Select inside if statement

Question

is there a possible way to have a select as an answer?, i'm trying to do this in MySql but it always appear as an error:

//administrador and informacion are tables. //inmobiliaria is the schema.

SELECT if(administrador.usuario='Admin0'&&administrador.password='pass123', 
select * from inmobiliaria.informacion, null) FROM inmobiliaria.administrador;

at the end i'm trying to get everything from the table "informacion" if the password and the user from the administrador table are the same as the typed in the text boxes, but i haven't found the way.

Do you have relation between administrador and informacion table ? — Almustafa Azhari
– Almustafa Azhari, Commented Mar 18, 2018 at 15:26
Looks like you are validating if the userid is Admin0 and password is correct. So you put the if statement first then do the select statement. You cannot do both at the same time. — jose_bacoy
– jose_bacoy, Commented Mar 18, 2018 at 15:28
There's no relation between administrator and informacion as i intended to use it for a log in a hidden form and the informacion would just be a simple editable gallery. should there be one? — Lopez93
– Lopez93, Commented Mar 18, 2018 at 15:30

Zohar Peled · Accepted Answer · 2018-03-18 15:40:21Z

1

It's kinda hard to tell what you want, but I think that your goal is something like select everything from inmobiliaria.informacion if the username and password are correct, or return null.

Please note that storing password as plain text in the database is a really, really bad idea. You should never store passwords as plain text. The correct way to handle passwords is to store a salted hash, so that even if someone would hack your database, the passwords can't be reverse engendered. For more information, read Salted Password Hashing - Doing it Right.

You can do something like this:

SELECT <ColumnsList>
FROM inmobiliaria.informacion
WHERE EXISTS
(
     SELECT 1
     FROM administrador
     WHERE usuario='Admin0'
     AND password='pass123'
)

This will return an empty result set if the user and password don't match.

answered Mar 18, 2018 at 15:40

Zohar Peled

82.9k11 gold badges79 silver badges134 bronze badges

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

1 Comment

Lopez93 Over a year ago

thank you so much! it works!, indeed, that's what i was trying to do, i'm sorry if i didn't express myself well.

Collectives™ on Stack Overflow

MySql: Select inside if statement

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related