Where子句包含mysql中的点扩展 - Where clause containing dots extension in mysql

Where clause containing dots extension in mysql

本文关键字：扩展 mysql 子句包含 Where | 更新日期: 2023-09-27

我有一个问题，这是从我的DB选择值。我有一个where子句，像这样:

$query = 'SELECT * FROM liquid 
          WHERE Id = '.$id.' 
          AND (
                    picone = tiger-1477927129.jpg OR 
                    pictwo = tiger-1477927129.jpg 
                    OR picthree = tiger-1477927129.jpg 
                    ' . 'picfour = tiger-1477927129.jpg 
                    OR picfive = tiger-1477927129.jpg
                    OR picsix = tiger-1477927129.jpg
          )';

问题是我在文件扩展名之前有点，所以sql不执行这个。你知道我怎么解决这个问题吗?

谢谢李

在值周围使用引号，例如image='image.jpg'，您需要在PHP中转义字符串的引号

 $query = 'SELECT * FROM liquid WHERE
    Id = '.$id.'
    AND (
        picone = ''tiger-1477927129.jpg''
        OR pictwo = ''tiger-1477927129.jpg''
        OR picthree = ''tiger-1477927129.jpg''
        OR picfour = ''tiger-1477927129.jpg''
        OR picfive = ''tiger-1477927129.jpg''
        OR picsix = ''tiger-1477927129.jpg''
    )
';