search string

[weetat <weetat.yeo@xxxxxxxxx>]

Hi all ,

 I am using php4.3.2,MYSQL and RedHat
 I have a sql text as shown below:


 SELECT 
DISTINCT(tbl_chassis.serial_no),tbl_chassis.host_name,tbl_chassis.chasis_model,tbl_chassis.country,tbl_chassis.city,tbl_chassis.building, 
tbl_chassis.other,tbl_chassis.status,tbl_chassis.chasis_eos,tbl_chassis.chasis_eol,tbl_chassis.chasis_user_field_1,tbl_chassis.chasis_user_field_2,tbl_chassis.chasis_user_field_3 
from tbl_chassis tbl_chassis,tbl_card tbl_card
WHERE tbl_chassis.serial_no = tbl_card.serial_no
AND tbl_chassis.chasis_model LIKE '%WS-C5500%'
AND lower(country) = lower(trim('Malaysia'))
ORDER BY country,city,building,other


I need to extract the "tbl_chassis.chasis_model LIKE '%WS-C5500%'" and 
"lower(country) = lower(trim('Malaysia'))" and join them to new string.

Anyone have any suggestion how to do this?

Thanks
-weetat

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