Need Small SQL Query to search the multiple tags from multiple Columns in the SQL Table. -- 2
$10-30 USD
Anulat
Data postării: peste 5 ani în urmă
$10-30 USD
Plata la predare
Need proper SQL Query for the following query:
For E.g. there are some records in the SQL DB Table as follows:
ID NAME DESCRIPTION
1 Test One This is the Test Record having test description
2 2nd Record This test record is the another one with sample text
When you are typing in words to search for an item and you hit return each time. Examples “test” “record” “text”
The search conducted should only be looking for items that match all three of the criteria and not just one of the criteria. Otherwise we are getting bad results, especially when you search like “test” “text”. It is giving us lots of items with just 'test', but are not related to 'text'.
Need SQL Query for the above.
Hey there,
recently i have worked on such type of searching and created a stored procedure, I can quickly provide you a solution within 1 day. Please give me this opportunity and you get exactly what you needed.
$23 USD în 1 zi
0,0 (1 recenzie)
0,0
0,0
11 freelanceri plasează o ofertă medie de $20 USD pentru proiect
Hi,
Being experienced in working on several Sql related projects of various complexities and can help you out in getting it done as needed in the mentioned description. Available to discuss now. Waiting for your response. Thanks.
I have good working skills in SQL and Good working skills in C#, VB, .NET, C++, Machine Learning, Java, XML, angularjs 5,MS Access VBA, Excel VBA,Word VBA.
Hello,
Greetings! My name is Amit Srivastava with an experience of 4+ years in java and web application development.I also have experience in workflow (BPMN) , ESB integration. . I can help you with to analyse, plan and implement if required.
I have done various projects that are connected to different database. My current works includes
1) Erp system - Postgresql database.
2) Expense management - MySQL database.
3) Betting App - MySQL and mongo DB
4) Iphone App - Amazon Dynamo DB
I can provide you required database query in 1 day and also can give documentation if required
Looking forward to hearing from you.
Regards,
Amit Srivastava
Skype: asrivastava2911
Pl let me know which DB it's and how to access from my end. Have 23 years of S/W development experience with DB.
The bid is for a single SQL.
Regards,
Chidambar Deshpande
Use like function from like. If you want a result that is related to test, text and bonus this is the query
select ... from.....
where columnname LIKE '%test%'
and columnname LIKE '%text%'
and columnname LIKE '%bonus%'
just change columnname to the name of the column you want to search for the texts