Re: [PHP-DB] SELECT Part of a Field

2003-08-29 Thread Ignatius Reilly
SUBSTRING()

_
- Original Message - 
From: Shaun [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 29, 2003 11:57 AM
Subject: [PHP-DB] SELECT Part of a Field


 Hi,
 
 How can I SELECT a portion of a field in a table for example the first
 character, or the second two characters etc?
 
 Thanks for your help
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 
 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP-DB] SELECT Part of a Field

2003-08-29 Thread Jacob A. van Zanen

Depending on the database you are using
Substring()
Substr()
Functions do what you want


jack



-Original Message-
From: Shaun [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 29, 2003 11:58 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] SELECT Part of a Field


Hi,

How can I SELECT a portion of a field in a table for example the first
character, or the second two characters etc?

Thanks for your help

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php