Search
 
SCRIPT & CODE EXAMPLE
 

SQL

first letter capital in mysql query

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

PREVIOUS NEXT
Code Example
Sql :: sql count columns 
Sql :: mysql show data from table 
Sql :: oracle list dates between 
Sql :: oracle apex list connected users 
Sql :: async await mysql nodejs 
Sql :: uninstall mysql server ubuntu 
Sql :: how to get the ddl for datafile in oracle tablespace 
Sql :: sql server loop over query 
Sql :: mysql tinyint max value 
Sql :: select sql in descending order 
Sql :: how to count null values in mysql 
Sql :: oracle stop 
Sql :: oracle search columns in schema 
Sql :: mysql with rollup 
Sql :: how to find the most occuring in SQL 
Sql :: mysql shell ERROR: Not connected. 
Sql :: having vs where sql 
Sql :: mysql change primary key 
Sql :: mysql select where not in multiple tables 
Sql :: how to delete git repo locally 
Sql :: update query formula in excel 
Sql :: mysql data types 
Sql :: size of all tables in a schema oracle 
Sql :: XOR in SQL Server 
Sql :: psql show columns of table 
Sql :: sql problems 
Sql :: MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES 
Sql :: mysql procedures 
Sql :: mysql concatenate select results 
Sql :: create index concurrently postgres 
ADD CONTENT
Topic
Content
Source link
Name
9+4 =