Muhammad Mateen Muhammad Mateen - 7 months ago 8
SQL Question

How to Select specific link from Database using query in Datatable

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

Answer

you can use this query to get specific results i guess it will help you out

select * from tablename WHERE columnName LIKE '%&p=3%'