Collections:
Function Name Case Insensitive
Are MySQL function names case sensitive?
✍: FYIcenter.com
No. MySQL function names are not case sensitive.
You can write function names in upper case or lower case.
For example:
SELECT PI(), pi(), Pi(); -- +----------+----------+----------+ -- | PI() | pi() | Pi() | -- +----------+----------+----------+ -- | 3.141593 | 3.141593 | 3.141593 | -- +----------+----------+----------+
Function argument modifiers are also not case sensitive. For example:
SET @str = 'Yahooo'; SELECT TRIM(BOTH 'o' FROM @str), trim(both 'o' from @str); -- +--------------------------+--------------------------+ -- | TRIM(BOTH 'o' FROM @str) | trim(both 'o' from @str) | -- +--------------------------+--------------------------+ -- | Yah | Yah | -- +--------------------------+--------------------------+
⇐ Calling MySQL Built-in Functions
2025-09-18, 1409🔥, 1💬
Popular Posts:
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...