I want to remove keys that match "user*".
How do I do that in redis command line?
Asked
Active
Viewed 1.7e+01k times
103
-
1in redis you don't remove keys but keys remove themselves. – max taldykin Mar 16 '12 at 12:50
11 Answers
102
Another compact one-liner I use to do what you want is:
redis-cli KEYS "user*" | xargs redis-cli DEL
user1151446
- 1,845
- 3
- 15
- 22
-
1This is great, thanks. It is sad that Redis doesn't have this functionality natively. – snapfractalpop May 09 '13 at 20:01
-
10If you have multible databases (keyspaces) then this is the trick: Lets say you need to delete keys in db3: `redis-cli -n 3 KEYS "prefix:*" | xargs redis-cli -n 3 DEL` – Christoffer May 19 '13 at 18:12
-
is there a one liner if you need to provide AUTH (i.e. login) prior to executing the delete command? – thames Nov 14 '13 at 00:39
-
'redis-cli help' says: -a
Password to use when connecting to the server. Hope it helps. – user1151446 Nov 15 '13 at 15:20 -
I had problems with this one. In case you have many entries to delete is better to use the awk based ones below. – Rafael Oct 16 '19 at 15:14
61
This is not a feature right now to be able to do in one shot (see the comments in the DEL documentation). Unfortunately, you are only left with using KEYS, looping through the results, and then using DEL to remove each one.
How about using bash a bit to help?
for key in `echo 'KEYS user*' | redis-cli | awk '{print $1}'`
do echo DEL $key
done | redis-cli
To step through it:
echo 'KEYS user*' | redis-cli | awk '{print $1}'-- get all the keys and strip out the extra text you don't want with awk.echo DEL $key-- for each one, create an echo statement to remove it.| redis-cli-- take the DEL statements and pass them back into the cli.
Not suggesting this is the best approach (you might have some issues if some of your usernames have spaces in them, but hopefully you get the point).
Donald Miner
- 38,889
- 8
- 95
- 118
6
Using awk, find all matching keys from redis using redis-cli KEYS command and pipe to redis-cli DEL command.
redis-cli KEYS "user*" | awk '{ system("redis-cli DEL " $1) }'
jeetu
- 81
- 1
- 8
6
Further to orangeoctopus' answer, you don't need the echo and pipe, you can pass commands as arguments into redis-cli. This means you can do
for key in `redis-cli "KEYS" "user*" | awk '{print $1}'`
do redis-cli "DEL" "$key"
done
neilkimmett
- 847
- 9
- 11
2
In order to delete all the redis keys of db 3:
redis-cli -n 3 --scan | xargs redis-cli -n 3 DEL
girino
- 21
- 2
2
If there are multiple keys in a pattern, for example : user1, user2, user3. To delete all keys which satisfy a pattern, use the below syntax.
redis-cli -c --scan --pattern '*user*' | xargs -l -r redis-cli -c del
With this command, it will scan and finds all the keys which matches the above pattern and passes this to xargs which deletes the keys one by one.
Note the use of -l arguments to delete keys one by one and -r to execute the delete command only if there is any input to the delete command.
Vineeth NG
- 240
- 3
- 22
1
Use this to remove redis keys having backslashes, quotes, double quotes or spaces:
redis-cli KEYS "user*" | sed 's/\\/\\\\/g' | sed 's/"/\\"/g' | sed "s/'/\\\\'/g" | sed 's/ /\\ /g' | xargs redis-cli DEL
make
- 41
- 2
0
I know this is old, but for those of you coming here form Google:
I just published a command line interface utility to npm and github that allows you to delete keys that match a given pattern (even , or as you asked user) from a Redis database.
You can find the utility here:
Gabriel McAdams
- 56,921
- 12
- 61
- 77
0
When using the oneliner, you can edit the pattern in case it escapes specific characters. For instance, to delete patterns like '\b test \b' use:
redis-cli --raw KEYS '\\b*' | sed 's/\\b/\\\\b/g' | xargs redis-cli del
Private
- 2,626
- 1
- 22
- 39
