2
No sql como faço para fazer um select com espaço e sem espaços?
That is, when I have a pass of the genus '123456' and '123456', the last one with space happens to be done in the query and I have '123456 ' in the bd should not show me field no visa that has a space and my parameter is '123456'
slq password= '&%$#"! ' this is the pass I have in sql that is equal to 123456, it happens that if you put 1234567 in it and should not enter it. 1234567 corresponds to '&%$#"! ' encoded.
Got it?
but if you have a space '123456 'in the login he enters and the pass is '123456'
– usersantos
@user2964140 User authentication selects and password in the database should compare if the password entered is EXACTLY EQUAL to the password stored in the bank, you should not disregard spaces or anything of the kind... Perhaps your question should be asked differently...
– Edson Horacio Junior
but the password is encrypted and can contain spaces
– usersantos
@user2964140 You must take the password entered by the user, apply the same encryption on this password and compare if the result is EXACTLY EQUAL to the one in the bank, this way you will not need to disregard anything, it is just an exact comparison.
– Edson Horacio Junior
yes already solved the problem with like 'asphalt%'
– usersantos
@user2964140 If this answer helped you, please mark it as the answer to your question.
– Edson Horacio Junior
is already marked
– usersantos