string problem
| From: | weetat | Date: | Mon, 10 Jul 2006 11:27:39 +0000 |
| Subject: | string problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-239245@lists.php.net to get a copy of this message | ||
Hi all ,
I am using PHP 4.3.2 , MYSQL database and Red Hat Entreprise OS.
I have the SQL statement which store in $str variable as shown below :
How to get the '%WS-X5225R%' from $str variable ?
$str = " SELECT DISTINCT(tbl_chassis.serial_no),tbl_card.card_model, ";
"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_card.card_model LIKE'%WS-X5225R%'";thanks