Yahoo Poland Wyszukiwanie w Internecie

Search results

1. www.w3schools.com › sql › func_mysql_upperMySQL UPPER() Function - W3Schools

   www.w3schools.com › sql › func_mysql_upper

   • Zapisane w pamięci cache

   Definition and Usage. The UPPER () function converts a string to upper-case. Note: This function is equal to the UCASE () function. Syntax. UPPER (text) Parameter Values. Technical Details. More Examples. Example. Convert the text in "CustomerName" to upper-case: SELECT UPPER (CustomerName) AS UppercaseCustomerName. FROM Customers;

   • Try It Yourself

     MySQL Database: Restore Database. Get your own SQL server...

2. stackoverflow.com › questions › 4263272string - Capitalize first letter. MySQL - Stack Overflow

   stackoverflow.com › questions › 4263272

   16 paź 2017 · If you want to upper-case the first letter and lower-case the other, you just have to use LCASE function : UPDATE tb_Company SET CompanyIndustry = CONCAT(UCASE(LEFT(CompanyIndustry, 1)), LCASE(SUBSTRING(CompanyIndustry, 2))); Note that UPPER and UCASE do the same thing.

3. www.mysqltutorial.org › mysql-string-functions › mysql-upperMySQL UPPER() Function - MySQL Tutorial

   www.mysqltutorial.org › mysql-string-functions › mysql-upper

   • Zapisane w pamięci cache

   The UPPER() function returns the uppercase of a specified string argument. The following shows the syntax of the UPPER() function: UPPER(str) Code language: SQL (Structured Query Language) (sql) In this syntax, the str is the argument to be converted to the uppercase.

4. www.geeksforgeeks.org › how-to-capitalize-first-letter-in-sqlHow To Capitalize First Letter in SQL? - GeeksforGeeks

   www.geeksforgeeks.org › how-to-capitalize-first-letter-in-sql

   • Zapisane w pamięci cache

   8 lip 2024 · This guide explores how to capitalize the first letter of a string in SQL, using functions like UPPER(), LOWER(), and SUBSTRING() in MySQL, ensuring your data is presented correctly and professionally.

5. www.tutorialkart.com › mysql › how-to-convert-strings-to-uppercase-in-mysqlHow to Convert Strings to Uppercase in MySQL - Tutorial Kart

   www.tutorialkart.com › mysql › how-to-convert-strings-to-uppercase-in-mysql

   • Zapisane w pamięci cache

   In MySQL, converting strings to uppercase is useful for data normalization, case-insensitive comparisons, or standardizing outputs in reports. Using the UPPER() Function in MySQL. The UPPER() function in MySQL takes a string as input and returns the entire string in uppercase. It can be applied to both literal strings and table column values.

6. mysqlcode.com › mysql-upper-ucaseMySQL UPPER() and UCASE() - How to convert text to uppercase in...

   mysqlcode.com › mysql-upper-ucase

   • Zapisane w pamięci cache

   25 gru 2020 · In this tutorial, we will study the MySQL UPPER () and UCASE () functions. Just like LOWER () and LCASE (), UPPER () and UCASE () are synonyms of each other in MySQL.

7. www.w3resource.com › mysql › string-functionsMySQL UPPER() function - w3resource

   www.w3resource.com › mysql › string-functions

   • Zapisane w pamięci cache

   20 lip 2023 · MySQL UPPER() converts all the characters in a string to uppercase characters. This function is useful in - Uppercase conversion: It allows you to convert a string to uppercase; Case-insensitive comparison: UPPER() can be used for case-insensitive string comparison.