What's the difference between LCASE() and LOWER() in MySQL?

I found places on the web that said they're similar but not a synonym for each other, so I'm not sure what the differences are?

Re: MySQL lcase vs lower differences? 80 80

They are synonymous, if you check the official docs it says as much. The reason they're both there is for familiarity, SQL Server and DB2 use lcase, Oracle and PostgreSQL use lower.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.