Apache Friends Support Forum

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

Why not simply use the '=' Operator?

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