MLB query using starting pitcher's previous game

59 views
Skip to first unread message

JT

unread,
Apr 20, 2022, 5:21:42 PMApr 20
to SportsDataBase
I'm trying to figure out how to query results based on the starting pitcher's previous performance. For example:

Games in which Gerrit Cole is starting, where in Cole's previous start he pitched at least 6 strikeouts

Any help would be appreciated.

Thanks

Gambrinus

unread,
Apr 20, 2022, 6:19:37 PMApr 20
to SportsDataBase

JT

unread,
Apr 20, 2022, 6:53:32 PMApr 20
to SportsDataBase
I checked a couple of the individual game results and it didn't seem to work, unless there's something I'm missing. For example, it returned the game on 9/14/21 for Cole, but his previous start was on 9/7 and he only had 2 strike outs.

Joe Meyer

unread,
Apr 21, 2022, 11:23:10 AMApr 21
to sportsdatabase
To get at the starter's stats in his previous start, use the parameter prefix `s`

best regards,

Joe Meyer
Sports Database LLC


--
You received this message because you are subscribed to the Google Groups "SportsDataBase" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sportsdatabas...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sportsdatabase/ac86caeb-3b99-4237-bddd-ac758c1ef0bfn%40googlegroups.com.

Gambrinus

unread,
Apr 21, 2022, 12:21:49 PMApr 21
to SportsDataBase
Yup, it's still early in the MLB season, and I'm still rusty. This is correct. 
  • starter='Gerrit Cole' and Starter:max:s:strike outs thrown>6

JT

unread,
Apr 21, 2022, 4:00:42 PMApr 21
to SportsDataBase
Great, thank you!
Reply all
Reply to author
Forward
0 new messages