Useful SQL queries

sqlQueries.md

Query for LIKE IN together

SELECT *
FROM `pincodeMaster`
WHERE stateName REGEXP '^ANDAMAN|ASSAM|BIHAR|Chattisgarh|DADRA|DAMAN|DELHI|GOA|HIMACHAL PRADESH|JAMMU|JHARKHAND|MADHYA PRADESH|MEGHALAYA|MIZORAM|NAGALAND|PONDICHERRY|RAJASTHAN|SIKKIM|TRIPURA|WEST BENGAL|TAMILNADU|Andhra Pradesh|Kerala|Karnataka|Maharashtra|Gujarat|Haryana|Punjab|Uttar Pradesh|Uttarakhand|Orrisa|Andrapradesh|Telangana (.*)'
GROUP BY stateName 

Will search for all the states that matches similar to like and case-insensitive too.

First letter Capital and rest all small

UPDATE tb_Company
SET CompanyIndustry = CONCAT(UCASE(LEFT(CompanyIndustry, 1)), 
                             LCASE(SUBSTRING(CompanyIndustry, 2)));