php - 查询在 MySQL Workbench 中运行但不在 php 中的 mysql_query() 中运行

Question

select t1.* 
from bbs_product as t1, bbs_category as t2 
where 
(((t1.product_name_de like '%13"%') or 
(t1.sku_number like '%13"%') or 
(t1.description like '%13"%')) and 
((t1.product_name_de like '%Laptoptasche%') or 
(t1.sku_number like '%Laptoptasche%') or 
(t1.description like '%Laptoptasche%')) and 
((t1.product_name_de like '%im%') or 
(t1.sku_number like '%im%') or 
(t1.description like '%im%')) and 
((t1.product_name_de like '%Buchdesign%') or 
(t1.sku_number like '%Buchdesign%') or 
(t1.description like '%Buchdesign%'))) and 
(t1.category_id=t2.id and t2.status=1) and 
t1.status=1 and 
t1.discontinued='no' and 
t1.is_secret='n'

Answer 1

t1.sku_number like '%13"%') or 
(t1.description like '%13"%')) and 

您的查询文本中有双引号。

确保它们在作为 mysql_query 参数的 PHP 字符串中正确转义。