Solved

Convert a database table column input to all small characters

Posted on 2014-11-13
7
134 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
[X]
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
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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

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

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

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

Suggested Solutions

I have a large data set and a SSIS package. How can I load this file in multi threading?
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 set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

738 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