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;

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)));

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

   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. The syntax for UPPER() is straightforward: </>. Copy. UPPER(string) Here, string can be any text or column that you want to convert to uppercase.

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. The UPPER() and UCASE() functions are string functions that are used to convert a string to uppercase alphabets.

7. www.tutorialspoint.com › mysql › mysql_upper_functionMySQL UPPER() Function - Online Tutorials Library

   www.tutorialspoint.com › mysql › mysql_upper_function

   • Zapisane w pamięci cache

   The MySQL UPPER () function is used to convert all the characters of a string to upper case letters. This function can be useful in various scenarios such as formatting text for consistent comparisons, normalization, etc.