How to write conditional select query in mysql

Question

I want to write a Login authentication query,

I want to check user Login and password if that is found in my database i fetch his details however if i cant find exact details i want to check if only the provided username exist in the table and get his name and profile pic.

i can do some thing like ..

SELCT * FROM `use_table` WHERE `username` = 'something' AND `password` = 'something'

if the above query returns empty rows then i fire another query

SELCT `name`, `profile_pic` FROM `use_table` WHERE `username` = 'something'

I can do this using multiple queries but the tricky part is i want to do this using a single query. ANY HELP ??

Pim Verlangen · Accepted Answer · 2014-03-21 14:42:31Z

0

Use NOT IN:

SELECT `name`, `profile_pic` 
FROM `use_table` 
WHERE `username` = 'something' 
AND NOT IN (
    SELECT * FROM `use_table`
    WHERE `username` = 'something' AND `password` = 'something'
)

answered Mar 21, 2014 at 14:42

Pim Verlangen

3871 silver badge11 bronze badges

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

1 Comment

Mohan Over a year ago

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IN ( SELECT * FROM

Red Wolf's Husband · Accepted Answer · 2014-03-21 14:45:32Z

0

quit easy, you just use the second query, but with password return like this:

SELCT `name`, `profile_pic`,`password` FROM `use_table` WHERE `username` = 'something'

Then you do a compare with user input password and password that retured

if they matches, then login ok, else login failed! but you also get the user's information!

answered Mar 21, 2014 at 14:45

Red Wolf's Husband

1451 gold badge1 silver badge8 bronze badges

1 Comment

Mohan Over a year ago

i thought about it .. and its a good idea but still i want to know if it is possible using a single query

Collectives™ on Stack Overflow

How to write conditional select query in mysql

2 Answers 2

1 Comment

Then you do a compare with user input password and password that retured

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Then you do a compare with user input password and password that retured

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related