Follow us on Twitter!
Become the change you seek in the world. - Gandhi
Wednesday, April 16, 2014
Navigation
Home
HellBoundHackers Main:
HellBoundHackers Find:
HellBoundHackers Information:
Learn
Communicate
Submit
Shop
Challenges
HellBoundHackers Exploit:
HellBoundHackers Programming:
HellBoundHackers Think:
HellBoundHackers Track:
HellBoundHackers Patch:
HellBoundHackers Other:
HellBoundHackers Need Help?
Other
Members Online
Total Online: 87
Guests Online: 86
Members Online: 1

Registered Members: 82803
Newest Member: Tired_of_being_ignorant
Latest Articles
View Thread

HellBound Hackers | HellBound Hackers | Questions

Author

Little question about wildcards in sql and login


Member

Your avatar

Posts:
Location:
Joined: 01.01.70
Rank:
Guest
Posted on 03-11-05 20:31
% 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?


Author

RE: Little question about wildcards in sql and login

knutrainer
Member



Posts: 243
Location:
Joined: 08.07.05
Rank:
Apprentice
Posted on 03-11-05 20:38
The * is a wild card.


img389.imageshack.us/img389/974/knu5ui1ja.jpg
~PM me if you need help or instant message me.


knutrainer@gmail.com
Author

RE: Little question about wildcards in sql and login


Member

Your avatar

Posts:
Location:
Joined: 01.01.70
Rank:
Guest
Posted on 03-11-05 20:40
No, % is not a wildcard (atleast not to my knowledge). I believe the symbol you're looking for would be the asterisk: *.


Author

RE: Little question about wildcards in sql and login


Member

Your avatar

Posts:
Location:
Joined: 01.01.70
Rank:
Guest
Posted on 03-11-05 20:54
oh ok, but still if i replace % with * or the wildcard for sql would it return true? Or will that only work with "like":
Code
WHERE password LIKE ''




?

Thanks :)




Edited by on 03-11-05 21:07
Author

RE: Little question about wildcards in sql and login

Mr_Cheese




Posts: 2468
Location: Brighton, UK
Joined: 30.11.04
Rank:
Uber Elite
Posted on 03-11-05 22:03
yeah, you got it! the % symbol, only works with LIKE


http://www.hellboundhackers.org/