Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 154
  • Last Modified:

Convert a database table column input to all small characters

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
peps03
Asked:
peps03
  • 4
  • 2
2 Solutions
 
Éric MoreauSenior .Net ConsultantCommented:
if it is MS SQL Server, you can use LOWER:

select LOWER(yourColumnName) from YourTableName

Open in new window

0
 
peps03Author Commented:
Thanks for your reply.

MS? meaning microsoft?

I have access to phpmyadmin. The os is cent os using directadmin.
0
 
Éric MoreauSenior .Net ConsultantCommented:
Yes MS is Microsoft. So why did you select "MS SQL Server" as one of the topic if it isn't related?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
peps03Author Commented:
oh, that was done accidentally i think.
0
 
Brian TaoSenior Business Solutions ConsultantCommented:
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
 
peps03Author Commented:
thanks, i was thinking of a db search and replace.
but lower casing the db input and output is also oke.
thanks!
0
 
peps03Author Commented:
:)
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now