QUERY: SELECT * FROM amphib where concat_ws(' ',genus,species) like '%Rana chapaensis%' order by genus, species

Number of matches: 2

Scientific Name	Photo	Sound	IUCN Red List Status	Vernacular Name	Family	Order
Nidirana chapaensis			Least Concern (LC)		Ranidae	Anura
Odorrana chapaensis			Near Threatened (NT)	Chapa Torrent Frog	Ranidae	Anura