[mythtv-users] mythtools v0.2
Ryszard
ryszard99 at gmail.com
Tue May 17 11:25:28 UTC 2005
will be included in the next rel.
On 5/16/05, John Williams <williamsbyron at gmail.com> wrote:
> > If anybody knows how to do a little text processing using perl/mysql,
> > and can throw together something to go through the database, select
> > all plots, and remove whitespace before and after, and put it back in,
> > that would be awesome too!
>
> It should look something like this
>
> <SQL>
> update tablename set descriptioncolumnname = trim(descriptioncolumnname)
> </SQL>
> this will update the description column to contain the same
> information with leading and trailing spaces removed. You will have to
> determine the column name and table name yourself. I'n m not near my
> Myth system.
>
> --
> I have plenty of Gmail invites. Ask me if you'd like one. G Mail rocks
> for email lists.
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
More information about the mythtv-users
mailing list