select navigationid from navigation where usertype = 'a' and navigationlink like '%thispage=subnavigation&category=扶乩及經書&s=經書寶懺&st=0']%' --- You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ']%'' at line 1