Re: MySQL substrings?

You can achieve the same effect by using left and right ----- Original Message ----- From: "Seb Frost" <seb@raceshoot.com> To: <php-general@lists.php.net> 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:mwaples@waples.net] > Sent: 19 August 2001 12:51 > To: php-general@lists.php.net > 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: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >