SQL = select * from plants where PUBLISH = 'yes' AND (COMMON_NAME LIKE "%mesquite%" OR
BOT_GENUS LIKE "%mesquite%" OR
BOT_SPECIES LIKE "%mesquite%" OR
BOT_ADDS LIKE "%mesquite%" OR
CHANGENM LIKE "%mesquite%" OR
SYN_ADDS LIKE "%mesquite%" OR
NOTES LIKE "%mesquite%" OR
SYNONYM LIKE "%mesquite%") ORDER BY BOT_GENUS, BOT_SPECIES ASC