Help me create a SQL statement to find spam in my forum database


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.


Evner: Forum Software, MySQL, SQL

Se mere: create sql 2005 database wss, create sql database html, create sql email database, delete all comments easily, wordpress delete pending comments sql, batch comment spam deletion, wordpress mark all comments as spam, delete spam comments wordpress, how to bulk delete comments in wordpress, wordpress delete all comments, phpmyadmin user database, wss create sql database, create sql database schema stored procedure database map, create sql database archives records weekly basis, create sql database customer order details code, create sql database bak, create sql database primavera, sql statement delete database, create sql database windows, oracle sql statement select employees database work projects

Om arbejdsgiveren:
( 20 bedømmelser ) North Balgowlah, Australia

Projekt ID: #17930711

Tildelt til:


Hi, my name is Krisnamourt a SQL Server DBA certified by microsoft with more than 8 years of experience, I'm also a Java/C# developer. During my experience I have always developed maintenance, migration and business r Flere

$10 AUD på 1 dag
(0 bedømmelser)

22 freelancere byder i gennemsnit $31 på dette 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.

$20 AUD in 0 dage
(28 bedømmelser)

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.

$35 AUD på 1 dag
(19 bedømmelser)

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

$25 AUD på 1 dag
(11 bedømmelser)

Hi iam expertise sql please let me know

$34 AUD in 3 dage
(9 bedømmelser)

Hi, I can decide rates from your side (price can be negotiated) I understand your requirement I have knowledge in this filed 5+ yr. kindly let me know in brief what kind of requirement do you have lets can show you my Flere

$29 AUD på 1 dag
(3 bedømmelser)

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

$20 AUD på 1 dag
(3 bedømmelser)

Hello Sir, I am SQL expert. This is a simple task for me to do. All I want to know to start work is structure of your database tables, to insure correct entities column name to filter. Looking forward to discuss detai Flere

$20 AUD på 1 dag
(4 bedømmelser)

I have gone through your requirement and things are clear to [login to view URL] share details and ping me for further discussion. Spare a moment on our previous work [login to view URL] [login to view URL] http://e Flere

$35 AUD på 1 dag
(2 bedømmelser)
$35 AUD på 1 dag
(1 bedømmelse)
$111 AUD in 3 dage
(0 bedømmelser)
$25 AUD in 4 dage
(0 bedømmelser)

I can do that

$25 AUD på 1 dag
(0 bedømmelser)

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,

$25 AUD på 1 dag
(0 bedømmelser)

Hello, since I'm new on this site I want to boost my profile, and that's the reason I'm offering half price amount for project. Feel free to contact me for more details. I have 5+ years working with databases and repor Flere

$20 AUD in 2 dage
(0 bedømmelser)
$35 AUD in 3 dage
(0 bedømmelser)

Hi There, I just started freelancing,I need some project to start. If you give me this opportunity I will not let you feel down. I have great understanding of SQL and [login to view URL] is my first priority so don't wo Flere

$10 AUD in 2 dage
(0 bedømmelser)

I have 7+ year experience in writing critical SQL's with optimized way. Also good hands on postgresql and mysql.

$27 AUD på 1 dag
(0 bedømmelser)

We have a good candidate to become a good developer and trustworthy developer and we should not break his trust.

$25 AUD på 1 dag
(0 bedømmelser)

Your request looks quite simple, shouldn't be any problem to successfully complete task.

$15 AUD på 1 dag
(0 bedømmelser)

I’m available. I’ll write a query which will the required results.

$55 AUD på 1 dag
(0 bedømmelser)