Little question about wildcards in sql and login

% is a wildcard in sql correct? Well i'm a totaly newbie with sql and php and was just wondering on basic 8 if you enter a % wouldn't it return true, as the error is: SELECT * FROM family_db WHERE password='%' so isn't that saying select all from the table family_db where the password is anything?

I hope i made sense?

The * is a wild card.

No, % is not a wildcard (atleast not to my knowledge). I believe the symbol you're looking for would be the asterisk: *.

oh ok, but still if i replace % with * or the wildcard for sql would it return true? Or will that only work with "like":

?

Thanks :)

yeah, you got it! the % symbol, only works with LIKE