adarsh r - Developer IT

Support Ticketing system

- by Adarsh Patil

Hi All, Could anyone recommend a good Support ticketing software? Preferably open source and easy to manage and backup. If one would recommend a commercial one, please do ? Thank you, Adarsh

Support Ticketing system

- by Adarsh Patil

Hi All, Could anyone recommend a good Support ticketing software? Preferably open source and easy to manage and backup. If one would recommend a commercial one, please do ? Thank you, Adarsh

Support Ticketing system

- by Adarsh Patil

Hi All, Could anyone recommend a good Support ticketing software? Preferably open source and easy to manage and backup. If one would recommend a commercial one, please do ? Thank you, Adarsh

How to increase backlinks of blog or websites [duplicate]

This question already has an answer here: How do I build backlinks? 5 answers I know that this question is very easy and also Silly.But I don't know how to make backlinks to my blog.I have tried commenting in various blogs and websites but in alexa there is only 1 backlink which is my own blog.Do anyone know how to make a quality backlinks for blog or website....I also want to know that by increasing Backlinks, SEO of my blog imporves???Thanks in advance......

Read the article

Searching a column containing CSV data in a MySQL table for existence of input values

- by Adarsh R

Hi, I have a table say, ITEM, in MySQL that stores data as follows: ID FEATURES -------------------- 1 AB,CD,EF,XY 2 PQ,AC,A3,B3 3 AB,CDE 4 AB1,BC3 -------------------- As an input, I will get a CSV string, something like "AB,PQ". I want to get the records that contain AB or PQ. I realized that we've to write a MySQL function to achieve this. So, if we have this magical function MATCH_ANY defined in MySQL that does this, I would then simply execute an SQL as follows: select * from ITEM where MATCH_ANY(FEAURES, "AB,PQ") = 0 The above query would return the records 1, 2 and 3. But I'm running into all sorts of problems while implementing this function as I realized that MySQL doesn't support arrays and there's no simple way to split strings based on a delimiter. Remodeling the table is the last option for me as it involves lot of issues. I might also want to execute queries containing multiple MATCH_ANY functions such as: select * from ITEM where MATCH_ANY(FEATURES, "AB,PQ") = 0 and MATCH_ANY(FEATURES, "CDE") In the above case, we would get an intersection of records (1, 2, 3) and (3) which would be just 3. Any help is deeply appreciated. Thanks

Developer IT