how to search key from table column based on user parameters

Posted by Gow.Net under Sql Server on 3/18/2013 | Points: 10 | Views : 684 | Status : [Member] | Replies : 4
hi
i am using MySQL server,based on user parameters search from my table column.example user give input as 'PHP,'JAVA','MYSQL' in my textboxes based on this how to search in single column,sometimes user give an 'PHP,'JAVA','MYSQL',Dotnet in my tetboxes (here multiple textboxes available) based on this how to search in single column i need some solution or idea for do that task please help me

gowthaman8870226416


Responses

Posted by: Murugavelmsc on: 3/18/2013 [Member] Starter | Points: 25

Up
0
Down
http://www.codeproject.com/Articles/33941/SQL-LIKE-Operator
http://databases.about.com/od/sqlserver/a/PatternMatching.htm

Regards,
Murugavel S
murugavel.sadagopan@gmail.com
http://murugavelmsc.blogspot.in/

Gow.Net, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Gow.Net on: 3/18/2013 [Member] Starter | Points: 25

Up
0
Down
hi Murugavelmsc sir

thanks for your replay,i need idea for how to pass no of parameter to procedure



gowthaman8870226416

Gow.Net, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jayakumars on: 3/18/2013 [Member] [MVP] Bronze | Points: 25

Up
0
Down
hi
concatenate all string and pass the values to db.

Mark as Answer if its helpful to you

Gow.Net, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sriramnandha on: 5/11/2013 [Member] Starter | Points: 25

Up
0
Down


SELECT * FROM TABLE NAME WHERE COLUMN NAME LIKE '%PHP%

SELECT * FROM TABLE NAME WHERE COLUMN NAME LIKE '%JAVA'





sriram

Gow.Net, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response