Search by Team - Revision history

Stalegum at 13:49, 23 July 2020

2020-07-23T13:49:14Z

← Older revision		Revision as of 09:49, 23 July 2020
Line 1:		Line 1:
	{{#tag:~~sql2wiki~~\|		{{
	~~SELECT year,~~num~~,setname~~,player,info~~,serial~~,team		#tag:SQL2Wiki
	~~FROM~~ cards		\|select num, player, info , team from cards where team like '%%search%%'
	~~\|database=carddb~~\|where=		\|where=search
	~~WHERE Team~~ = ~~'%1%'~~		\|database=carddb
	\|message=~~Enter team (i.e. Tigers)~~:}}		\|message=Search:

			}}


	[[Category:Baseballcardpedia]]		[[Category:Baseballcardpedia]]

Stalegum at 13:48, 23 July 2020

2020-07-23T13:48:22Z

← Older revision		Revision as of 09:48, 23 July 2020
Line 3:		Line 3:
	FROM cards		FROM cards
	\|database=carddb\|where=		\|database=carddb\|where=
	WHERE Team = '%1'		WHERE Team = '%1%'
	\|message=Enter team (i.e. Tigers):}}		\|message=Enter team (i.e. Tigers):}}

	[[Category:Baseballcardpedia]]		[[Category:Baseballcardpedia]]

Stalegum at 16:55, 29 August 2014

2014-08-29T16:55:54Z

← Older revision		Revision as of 12:55, 29 August 2014
Line 6:		Line 6:
	\|message=Enter team (i.e. Tigers):}}		\|message=Enter team (i.e. Tigers):}}

	~~{{#tag:sql2wiki\|~~
	~~SELECT year,num,setname,player,info,serial,team~~
	~~FROM cards~~
	~~\|database=carddb\|where=~~
	~~WHERE info = 'RC'~~
	~~\|message=Enter team (i.e. Tigers):}}~~
	[[Category:Baseballcardpedia]]		[[Category:Baseballcardpedia]]

Stalegum at 16:55, 29 August 2014

2014-08-29T16:55:35Z

← Older revision		Revision as of 12:55, 29 August 2014
Line 6:		Line 6:
	\|message=Enter team (i.e. Tigers):}}		\|message=Enter team (i.e. Tigers):}}

			{{#tag:sql2wiki\|
			SELECT year,num,setname,player,info,serial,team
			FROM cards
			\|database=carddb\|where=
			WHERE info = 'RC'
			\|message=Enter team (i.e. Tigers):}}
	[[Category:Baseballcardpedia]]		[[Category:Baseballcardpedia]]

Just me at 03:01, 14 December 2011

2011-12-14T03:01:05Z

← Older revision		Revision as of 23:01, 13 December 2011
Line 5:		Line 5:
	WHERE Team = '%1'		WHERE Team = '%1'
	\|message=Enter team (i.e. Tigers):}}		\|message=Enter team (i.e. Tigers):}}


			[[Category:Baseballcardpedia]]

Chris at 14:44, 20 April 2011

2011-04-20T14:44:11Z

← Older revision		Revision as of 10:44, 20 April 2011
Line 1:		Line 1:
	{{#tag:sql2wiki\|		{{#tag:sql2wiki\|
	SELECT year,num,setname,player,info,serial		SELECT year,num,setname,player,info,serial,team
	FROM cards		FROM cards
	\|database=carddb\|where=		\|database=carddb\|where=
	WHERE Team = '%1'		WHERE Team = '%1'
	\|message=Enter team (i.e. Tigers):}}		\|message=Enter team (i.e. Tigers):}}

Chris at 14:09, 20 April 2011

2011-04-20T14:09:39Z

← Older revision		Revision as of 10:09, 20 April 2011
Line 1:		Line 1:
	{{#tag:sql2wiki\|		{{#tag:sql2wiki\|
	SELECT year,setname,~~num~~,~~player~~		SELECT year,num,setname,player,info,serial
	FROM cards		FROM cards
	\|database=carddb\|where=		\|database=carddb\|where=
	WHERE Team = '%1'		WHERE Team = '%1'
	\|message=Enter team (i.e. Tigers):}}		\|message=Enter team (i.e. Tigers):}}

Chris at 14:40, 19 April 2011

2011-04-19T14:40:47Z

← Older revision		Revision as of 10:40, 19 April 2011
Line 1:		Line 1:
	{{#tag:sql2wiki\|		{{#tag:sql2wiki\|
	SELECT year,setname,num		SELECT year,setname,num,player
	FROM cards		FROM cards
	\|database=carddb\|where=		\|database=carddb\|where=
	WHERE Team = '%1'		WHERE Team = '%1'
	\|message=Enter team (i.e. Tigers):}}		\|message=Enter team (i.e. Tigers):}}

Chris: Created page with '{{#tag:sql2wiki| SELECT year,setname,num FROM cards |database=carddb|where= WHERE Team = '%1' |message=Enter team (i.e. Tigers):}}'

2011-04-19T14:40:23Z

Created page with '{{#tag:sql2wiki| SELECT year,setname,num FROM cards |database=carddb|where= WHERE Team = '%1' |message=Enter team (i.e. Tigers):}}'

New page

{{#tag:sql2wiki|
SELECT year,setname,num
FROM cards
|database=carddb|where=
WHERE Team = '%1'
|message=Enter team (i.e. Tigers):}}