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	photos		Least Concern (LC)		Ranidae	Anura
Odorrana chapaensis	photos		Near Threatened (NT)	Chapa Torrent Frog	Ranidae	Anura