Delete only certain database entries

  • Resolved dbfischer

    (@dbfischer)


    10 months ago

    Hi, how can I delete only certain database entries?
    I have CleverReach newsletter plugin installed and it made a lot of unnecessary enries, so the database is too big.
    Is there a way to delete only entries with
    “/?cleverreach_wc_controller=Async_Process&action=run&guid=*”?
    * are different numbers

    Thanks for your help and regards
    Dirk

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Mostafa Soufi

    (@mostafas1990)

    Hey,

    You can delete that certain entiries on the database by the below query

    DELETE FROM wp_slim_stats WHERE referer like '%/?cleverreach_wc_controller=Async_Process&action=run&guid=*%';
    Thread Starter dbfischer

    (@dbfischer)

    Thank you Mostafa!
    I just had to change “referer” to “resource” and remove the “*”.
    Then it worked fine and deleted over a million useless entries. ??

    Plugin Author Mostafa Soufi

    (@mostafas1990)

    Good to hear!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Delete only certain database entries’ is closed to new replies.