Real Vim ninjas count every keystroke - do you?

Pick a challenge, fire up Vim, and show us what you got.

Changelog, Rules & FAQ, updates: @vimgolf, RSS.

Your VimGolf key: please sign in

$ gem install vimgolf
$ vimgolf setup
$ vimgolf put 9v0066d8266e000000000367

Search different SQL column with similar where clause

Replace a column in the where clause and convert all numbers from text to numeric, by replacing the leading 0 with the code 359.

Start file
SELECT * FROM numbers WHERE local_number IN (
	"058307327",
	"058307328",
	"058307329"
)
End file
SELECT * FROM numbers WHERE int_number IN (
	35958307327,
	35958307328,
	35958307329
)

View Diff

1,4c1,4
< SELECT * FROM numbers WHERE local_number IN (
< 	"058307327",
< 	"058307328",
< 	"058307329"
---
> SELECT * FROM numbers WHERE int_number IN (
> 	35958307327,
> 	35958307328,
> 	35958307329

Solutions by @leonkacowicz:

Unlock 13 remaining solutions by signing in and submitting your own entry
Created by: @stoyandimov

60 active golfers, 265 entries

Solutions by @leonkacowicz:
22
#14 - Leon Kacowicz / @leonkacowicz

05/05/2025 at 11:58PM

23
#>24 - Leon Kacowicz / @leonkacowicz

05/05/2025 at 11:56PM

23
#>24 - Leon Kacowicz / @leonkacowicz

05/05/2025 at 11:57PM

24
#>27 - Leon Kacowicz / @leonkacowicz

05/05/2025 at 11:54PM

25
#>33 - Leon Kacowicz / @leonkacowicz

05/05/2025 at 11:54PM

25
#>33 - Leon Kacowicz / @leonkacowicz

05/06/2025 at 12:06AM

26
#>36 - Leon Kacowicz / @leonkacowicz

05/05/2025 at 11:52PM

27
#>42 - Leon Kacowicz / @leonkacowicz

05/05/2025 at 11:51PM

28
#>47 - Leon Kacowicz / @leonkacowicz

05/05/2025 at 11:50PM

30
#>48 - Leon Kacowicz / @leonkacowicz

05/05/2025 at 11:49PM

32
#>50 - Leon Kacowicz / @leonkacowicz

05/05/2025 at 11:46PM

32
#>50 - Leon Kacowicz / @leonkacowicz

05/05/2025 at 11:47PM

35
#>53 - Leon Kacowicz / @leonkacowicz

05/05/2025 at 11:46PM