You can achieve the same effect by using left and right
----- Original Message -----
From: "Seb Frost" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 19, 2001 3:12 PM
Subject: [PHP] MySQL substrings?


> This is thew sort of thing I want:
>
> SELECT * FROM table ORDER BY substr(field,5,6)
>
> but I don't know the correct function, if there is one, or how to
implement
> it.
>
> cheers,
>
> - seb
>
> -----Original Message-----
> From: Michael [mailto:[EMAIL PROTECTED]]
> Sent: 19 August 2001 12:51
> To: [EMAIL PROTECTED]
> Subject: [PHP] Re: transaction
>
>
> Nafiseh Saberi wrote:
> >
> > hi.
> > in large database with php,postgres
> > and when in each time come many request ,
> > how do we implement transactions??
>
> > nafiseh.
>
> If you are wanting to run several queries in the one script though the
> one transaction -
> you'll need to send a begin(as a query) and execute it - then to the
> same connection send all your other queries as normal, and follow it up
> with a commit.
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to