我想从我的一个数据库字段中删除任何中断标记,并将其替换为空格。所以我尝试了以下操作:
$select = SELECT ID, REPLACE(fieldname, "<BR>", " ") FROM mytable
,但这会导致一个意想不到的>错误。我也尝试过'<BR>'
,但这只是使csv中的字段名称更改为REPLACE(fieldname, '<BR>', ' ')
mysql_query()呢?
$select = mysql_query('SELECT ID, REPLACE(fieldname, "<BR>", " ") FROM mytable');
我试过从phpMyAdmin
CREATE TABLE `mytable` (
`ID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`fieldname` TEXT NOT NULL
) ENGINE = MYISAM ;
INSERT INTO `usr_web106_38`.`mytable` (`fieldname`)VALUES ('test <BR> test <BR>');
和查询工作:
SELECT ID, REPLACE( fieldname, "<BR>", " " ) FROM mytable;
ID REPLACE(fieldname, "<BR>", " ")
1 test test
PHP
也是如此$select = mysql_query('SELECT ID, REPLACE(fieldname, "<BR>", " ") FROM mytable');
echo "<pre>"; var_dump(mysql_fetch_array($select) ); echo "</pre>";
结果array(4) {
[0]=>
string(1) "1"
["ID"]=>
string(1) "1"
[1]=>
string(13) "test test "
["REPLACE(fieldname, "
", " ")"]=>
string(13) "test test "
}
不管你有什么问题。
<?php
$select = SELECT ID, REPLACE(fieldname, "<BR>", " ") FROM mytable
//1 : Syntax Error no quotes & semicolon
$select = 'SELECT ID, REPLACE(fieldname, "<BR>", " ") FROM mytable';
//2 : you've to run query
mysql_query($select);
?>