Join us at IRC!
Understanding is the answer, hatred is the problem, and hackers are the slaves abused and destroyed in the process of peace online - Deshouleres
Thursday, May 24, 2012
Navigation
Members Online
Total Online: 36
Web Spiders: 13
Guests Online: 31
Members Online: 5

Registered Members: 70200
Newest Member: ScubaSteve
Latest Articles
View Thread

HellBound Hackers | HellBound Hackers | Questions

Author

Little question about wildcards in sql and login

kolicha
Member

Posts: 3
Location:
Joined: 02.11.05
Rank:
Wiseman
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?


* no questions asked *
http://www.vthemes.co.uk
Author

RE: Little question about wildcards in sql and login

knutrainer
Member



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



~PM me if you need help or instant message me.


knutrainer@gmail.com
Author

RE: Little question about wildcards in sql and login

CNS Chemist
Member

Posts: 187
Location: i'm a racist, educate me.
Joined: 10.03.05
Rank:
Moderate
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: *.


i'm a racist, educate me.
Author

RE: Little question about wildcards in sql and login

kolicha
Member

Posts: 3
Location:
Joined: 02.11.05
Rank:
Wiseman
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":
WHERE password LIKE ''

?

Thanks :)


* no questions asked *

Edited by kolicha on 03-11-05 21:07
http://www.vthemes.co.uk
Author

RE: Little question about wildcards in sql and login

Mr_Cheese
HBH Owner



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


Guest
Username

Password

Remember Me


Bookmark This Page
Affiliates
Adverts

 

 

Links
By using, viewing or obtaining any information contained on this site, you agree to the disclaimer.

© HellBound Hackers 2008- 2009. Since 3rd December 2004.