|
|
|
|
Menu |
|
|
Home |
| |
|
Discussions |
| |
|
Tools |
| |
|
Affiliates |
| |
|
Content |
| |
|
Info |
| | |
|
|
|
|
|
User Info |
|
Membership:
Latest: MichaelSnaRe
New Today: 0
New Yesterday: 0
Overall: 9144
People Online:
Visitors: 82
Members: 0
Total: 82
|
|
|
|
|
|
Full disclosure |
|
|
|
|
|
|
|
|
|
IT Security and Insecurity Portal |
|
|
MSSQL Like |
|
Posted: Wed Aug 05, 2009 9:32 pm |
|
|
delta |
Advanced user |
|
|
Joined: Jan 11, 2009 |
Posts: 60 |
|
|
|
|
|
|
|
Well, I'm trying to use LIKE in a sql injection query in MSSQL but it's not working as expected --'
I'm trying:
FROM table WHERE column LIKE '123%' order by ...
But insted of returning the the records that start with 123, i get records that are 123
The syntax is correct:
http://msdn.microsoft.com/en-us/library/aa933232(SQL.80).aspx
Server Info:
Version Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Any idea ?
Thanks |
|
|
|
|
Posted: Thu Aug 06, 2009 8:31 pm |
|
|
delta |
Advanced user |
|
|
Joined: Jan 11, 2009 |
Posts: 60 |
|
|
|
|
|
|
|
|
|
|
|
Posted: Thu Aug 06, 2009 11:25 pm |
|
|
tehhunter |
Valuable expert |
|
|
Joined: Nov 19, 2008 |
Posts: 261 |
|
|
|
|
|
|
|
One idea that comes to mind is that maybe, for some reason, your wildcard character (%) is being removed from the query. Try using the hex or ascii equivalents. |
|
|
|
|
Posted: Thu Aug 06, 2009 11:41 pm |
|
|
delta |
Advanced user |
|
|
Joined: Jan 11, 2009 |
Posts: 60 |
|
|
|
|
|
|
|
hahaha You're right.
Used %25 insted of % and worked.
Feeling very stupid now
hehe, thx for the help tehhunter |
|
|
|
|
www.waraxe.us Forum Index -> Sql injection
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
All times are GMT
Page 1 of 1
|
|
|
Powered by phpBB © 2001-2008 phpBB Group
|
|
|
|
|
|
|