Solved

Convert a database table column input to all small characters

Posted on 2014-11-13
7
131 Views
Last Modified: 2014-11-13
Hi,

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.

Thanks!
0
Comment
Question by:peps03
  • 4
  • 2
7 Comments
 
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

0
 

Author Comment

by:peps03
ID: 40439833
Thanks for your reply.

MS? meaning microsoft?

I have access to phpmyadmin. The os is cent os using directadmin.
0
 
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?
0
Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

 

Author Comment

by:peps03
ID: 40439879
oh, that was done accidentally i think.
0
 
LVL 9

Accepted Solution

by:
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?
0
 

Author Comment

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

Author Closing Comment

by:peps03
ID: 40440476
:)
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

This article discusses how to create an extensible mechanism for linked drop downs.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to shrink a transaction log file down to a reasonable size.
The viewer will learn how to count occurrences of each item in an array.

679 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