search string
| From: | weetat | Date: | Thu, 20 Jul 2006 09:53:12 +0000 |
| Subject: | search string | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-239614@lists.php.net to get a copy of this message | ||
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