query by column for substring sql

Solutions on MaxInterview for query by column for substring sql by the best coders in the world