Web Developers Portal
learn and share
Showing posts with label
sql
.
Show all posts
Showing posts with label
sql
.
Show all posts
Tuesday, 21 May 2013
Remove Carriage return in varchar column in sql
›
Issue I have a mysql table with VARCHAR column which contains String values. Sometimes at the end of the string there is a carriage retur...
Remove a character from a string in mysql
›
Issue I have a mysql table with a column name "sequence". sequence column contains protein sequence starting with "protei...
Trim all the values in a column in a sql
›
Trim all the values in a column in a sql SQL does not have a trim function. You'll need to use RTRIM and LTRIM together. update My...
›
Home
View web version