I have a phpBB forum that has accumulated a number of spam posts over the years.
I need to create a simple SQL statement that will find the posts
that contain the strings:
that don't contain the strings
What should be returned by the query is just the post id and the URL contained in the post. This data must be able to be exported to Excel.
This work must not change the DB structure.
Must not create a performance issue and crash the DB.
This should be a very quick and simple project as it's just a small SQL statement that someone with the skill can write in a few minutes.
I'll also need you to work with me as I run the script on the DB and make any revisions needed to perfect the results so that I can capture spam postings.
You will not be provided with DB access, so you will need to write queries and pass them to be to run.
22 freelancers are bidding on average $31 for this job
Hi! I'm senior lecturer on databases with 10+ years of experience in dbms. I can create any sql statement, now you need easy sql statement, i can create if you send me structure of your db.
Hi. I have read your description and have interests in your project. I am sure I can do your project. I would like to have a discussion with chat to get more about your project. Thanks.
hi there , let me know the detail of you database its on mysql or mssql . i can able to make this query . do you need this one in procedure of function so you can implement where you want regards tscreators
I can do this for you, I don't remember the table structure of phpBB, but I think this is a simple Query that can give it to you so you can run it on MySQL admin and export it to an excel
I have 10 years of exp in oracle ebs so i hope, my profile will suit the requirements. I worked on SQL, PLSQL, ORACLE EBS R12, R12 upgrade etc for the multiple global clients like GE, Agilent, CITI, EATON, AMEX etc,