Reputation: 138
i have 117 links of paging=3 like
http://www.shophive.com/apple?cat=22& p=2
and 3 links of paging=3 like
http://www.shophive.com/apple?cat=19&p=3
i want to select just links of p=2 through Data table in C# sql , contains and Not IN query is not working
Upvotes: 1
Views: 41
Reputation: 227
you can use this query to get specific results i guess it will help you out
select * from tablename WHERE columnName LIKE '%&p=3%'
Upvotes: 1