LCASE can be used in MySQL query to get the output in all lower case letters.
For example below query will display the username in lowercase.
SELECT lcase(username) FROM `users`
Similarly UCASE can be used for getting the output in all upper case letters.
Alternatively, we can use php functions strtolower() and strtoupper() for achieving the samething.
More Articles...
Shop at Rajamanickam.com | Trending: Birthday Gift Idea? | Free Quotes App
Get 3 useful ebooks for Rs 99 in India and $5.99 globally
Get a 50% commission | One-On-One Coaching of ChatGPT and Gemini
Search This Blog
Art of Talking to AI | Tech eBook | Dream Big | Listen to Dream Big
Today's Deals | Timesheet | Products | 3 ebooks for $5.99 / Rs 99 | Earn 50% commission
About | Privacy | Follow | TOS | WhatsApp | Contact
I may earn a commission from Amazon affiliate links
Today's Deals | Timesheet | Products | 3 ebooks for $5.99 / Rs 99 | Earn 50% commission
About | Privacy | Follow | TOS | WhatsApp | Contact
I may earn a commission from Amazon affiliate links
No comments:
Post a Comment