Re: MySQL substrings?

There is a SUBSTRING() function, its just hard to find with their search system. /* Chris Lambert, CTO - chris@whitecrown.net WhiteCrown Networks - More Than White Hats Web Application Security - www.whitecrown.net */ ----- Original Message ----- From: Tom Carter <subs@roundcorners.com> To: Seb Frost <seb@raceshoot.com>; <php-general@lists.php.net> Sent: Sunday, August 19, 2001 10:32 AM Subject: Re: [PHP] 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 | > | | | -- | 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 | | |