I may be missing something, but wouldn't a substring(bigdata, 0,instring("--header
end--")) suffice? Of course, my syntax is all kinds of wrong... but you get the
idea...
> -----Original Message-----
> From: Jan Magnusson [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 23, 2003 10:56 AM
> To: Mysql General mailing list
> Subject: RE: making specific query for big data
>
>
> I think he is looking for a way to just retrieve some data prior to a
> specific (although dynamic) point of the full data saved in a longtext
> datatype column.
>
> Like retrieving just the header of email messages saved with
> attachments etc
> in a longtext column.
>
> Perhaps having that header data saved in a separate column
> would fulfill the
> purpose...
>
> Jan
>
> -----Original Message-----
> From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED]
> Sent: Thursday, October 23, 2003 17:16
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: making specific query for big data
>
>
> I don't understand well. Are you looking for the MAX value of
> a column? Or
> its data size?
>
>
> Thanks
> Emery
> ----- Original Message -----
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, October 23, 2003 12:21
> Subject: making specific query for big data
>
>
> > Hello all..
> >
> > so
> > Is it possible to do this:
> > make query on mysql
> > ask to select from blabla where bigdata=????
> > but tell to get only all data before --header end-- string into it
> >
> > so it will give in result only strings what are found
> before --header
> end--
> >
> > becouse after this string goes very big data
> > ps. bigdata field is "longtext"
> >
> > ok.. there is whole picture of this:
> > I have longtext field
> > I need to get only data before --header end-- (or any other pattern)
> > so in result it will give only info before that pattern
> >
> > is it possible to as mysql to get some data from field not alll
> >
> > -- Tavs bezmaksas pasts Inbox.lv
> > ___________________________________
> > FLASH GAMES - http://games.inbox.lv
> >
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
