Best Function to use to compare passwords in MySQL?

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Best Function to use to compare passwords in MySQL?

Postby wasabihowdi » 29. January 2008 06:17

Hi~

I would like to know what is the best function to use for MySQL in order to compare, let's say, the user password with the ones stored in the tables? Should I use the function "LIKE"? (in my case, password is a string - contain both numbers and letters). Or, it will be better to do it in PHP?

Thanks so much! ^^

Howdi
wasabihowdi
 
Posts: 11
Joined: 24. January 2008 06:23

Postby Scory » 29. January 2008 11:26

Why not simply use the '=' Operator?

Select blabla from table WHERE user = 'username' AND password = 'slfkhjlsdjklksjdf'
Scory
 


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 147 guests