Delete Redis Keys matching a pattern Laravel 5.7

Question

I have been searching and tried multiple solution but could got any helping results, I want to clear/delete all keys matching pattern products:*.

Following are the things i have tried.

Redis::del('products:*');
Redis::del('*products:*');
Redis::del('*products*');

But nothing worked.

It is deleting key if i provide exact key name like : Redis::del('products:2:3:45');

Key are being generated like this: products:1:4:45

I have read documentation but could find anything regarding my query.

Please help.

See stackoverflow.com/questions/32295488/…. This may solve your problem — Ali Khalili
– Ali Khalili, Commented Oct 22, 2019 at 14:09

freeek · Accepted Answer · 2019-10-22 14:08:12Z

25

You can't delete by pattern. But you can get all the keys by this pattern and then delete them:

Redis::del(Redis::keys('products:*'));

See more here.

answered Oct 22, 2019 at 14:08

freeek

9889 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Lounis Over a year ago

Working like a charm with Laravel Framework 9.3.0.

Nsagha Kingsly Over a year ago

Not working with Laravel 10.x

Moode Osman · Accepted Answer · 2020-11-26 21:53:56Z

5

With Laravel 8 it wasn't deleting cause the key has a prefix so what I did is remove the prefix before passing it to del()

$keys = Redis::keys( 'products:*' );

if ( !empty( $keys ) ){
    $keys = array_map(function ($k){
        return str_replace('_prefix_database', '', $k);
    }, $keys);

    Redis::del( $keys );
}

i hope this will be helpful for someone

answered Nov 26, 2020 at 21:53

Moode Osman

2,05322 silver badges17 bronze badges

1 Comment

Christine Treacy Over a year ago

This worked well in Laravel 7 also. Thanks!

Danyal Sandeelo · Accepted Answer · 2024-07-11 09:26:03Z

4

I read somewhere that you cannot delete based on wildcard, you need to give the keys explicitly.

There is still a way to grab all keys and then runs delete on those keys. I do it using cli like this:

redis-cli KEYS "products:*" | xargs redis-cli DEL

It fetches all the keys that match the query and run DEL on them. You can execute this command from Laravel.

In Laravel, fetch all keys and run delete on them using

Redis::del(Redis::keys('products:*'));

edited Jul 11, 2024 at 9:26

answered Oct 22, 2019 at 14:18

Danyal Sandeelo

12.4k10 gold badges57 silver badges90 bronze badges

Comments

Nick · Accepted Answer · 2019-10-22 15:49:20Z

1

We can use the array_map function to go over all the keys in redis and do delete.

$redis = new Redis;
$prefix = $redis->getOption(Redis::OPT_PREFIX);
$redis->delete(array_map(
    function ($key) use ($prefix) {
        return str_replace($prefix, '', $key);
    }, $redis->keys('*'))
);

edited Oct 22, 2019 at 15:49

answered Oct 22, 2019 at 14:13

Nick

5462 silver badges8 bronze badges

2 Comments

Danyal Sandeelo Over a year ago

Please share the source when you copy paste from another source

Nico Haase Over a year ago

Please add some explanation to your answer such that others can learn from it

vlauciani · Accepted Answer · 2021-01-14 17:41:14Z

0

With Laravel8 I use:

    public function handle()
    {
        $this->call('queue:flush');

        $arrayFailed        = Redis::connection('horizon')->keys('failed:*');
        $arrayFailedJobs    = Redis::connection('horizon')->keys('failed_jobs');
        $arrayToRemove      = array_merge($arrayFailed, $arrayFailedJobs);

        $arrayMap = array_map(function ($k) {
            return str_replace(config('horizon.prefix'), '', $k);
        }, $arrayToRemove);
        Redis::connection('horizon')->del($arrayMap);

        $this->line('');
    }

answered Jan 14, 2021 at 17:41

vlauciani

1,1002 gold badges14 silver badges30 bronze badges

Comments

masud_moni · Accepted Answer · 2025-07-15 01:37:28Z

0

In my case using Laravel 8.x and "predis/predis": "^2.1", I have noticed that the package added a prefix "laravel_database_" so I had to remove it everytime I delete Redis hashes, I achieved that like so:

function DeleteRedisKeys($hash){
    $prefix = 'laravel_database_';
    $keys = Redis::keys($hash . '*');
    $keys = array_map(function ($h) use ($prefix) {
        return str_replace($prefix, '', $h);
    }, $keys);
    Redis::del($keys);
}

edited Jul 15 at 1:37

masud_moni

1,30619 silver badges34 bronze badges

answered May 23, 2024 at 11:36

Abdessamad Zenasni

13 bronze badges

Collectives™ on Stack Overflow

Delete Redis Keys matching a pattern Laravel 5.7

6 Answers 6

2 Comments

1 Comment

Comments

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

2 Comments

1 Comment

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related