Convert a database table column input to all small characters

Posted on 2014-11-13
Last Modified: 2014-11-13

How can i easily convert all of a table column's input to all small characters?
The column contains image names. These need to be converted to all small chars.

Question by:peps03
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
LVL 70

Assisted Solution

by:Éric Moreau
Éric Moreau earned 250 total points
ID: 40439810
if it is MS SQL Server, you can use LOWER:

select LOWER(yourColumnName) from YourTableName

Open in new window


Author Comment

ID: 40439833
Thanks for your reply.

MS? meaning microsoft?

I have access to phpmyadmin. The os is cent os using directadmin.
LVL 70

Expert Comment

by:Éric Moreau
ID: 40439854
Yes MS is Microsoft. So why did you select "MS SQL Server" as one of the topic if it isn't related?
What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.


Author Comment

ID: 40439879
oh, that was done accidentally i think.

Accepted Solution

Brian Tao earned 250 total points
ID: 40440249
Do you mean you need to change the letter case for existing records in the database table column? or do you want to force all future incoming input for the column to be in lowercase?

Author Comment

ID: 40440474
thanks, i was thinking of a db search and replace.
but lower casing the db input and output is also oke.

Author Closing Comment

ID: 40440476

Featured Post

Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question