我现在想实现把数据表里面数据title字段前两个字为 北京 的记录的infozm字段更新为:B在phpmyadmin 里mysql运行:
UPDATE `daifu8`.`ayrweb_ecms_yiyuan` SET `infozm` = 'H' WHERE substring(`daifu8`.`ayrweb_ecms_yiyuan`.`title`,1,4)="合肥" LIMIT 1
影像了0列。请教!~~
UPDATE `daifu8`.`ayrweb_ecms_yiyuan` SET `infozm` = 'H' WHERE substring(`daifu8`.`ayrweb_ecms_yiyuan`.`title`,1,4)="合肥" LIMIT 1
影像了0列。请教!~~
UPDATE `daifu8`.`ayrweb_ecms_yiyuan` SET `infozm` = 'H' WHERE substring(`daifu8`.`ayrweb_ecms_yiyuan`.`title`,1,4) like "合肥%" LIMIT 1
这样就可以了