Hello,
How to fix database error when the tag contain special characters like % ' ...
for example:
SELECT COUNT(*) FROM `RayVideoFiles` left JOIN `Profiles` ON
`Profiles`.`ID`=`RayVideoFiles`.`Owner` left JOIN `sys_albums_objects`
ON `sys_albums_objects`.`id_object`=`RayVideoFiles`.`ID` left JOIN
`sys_albums` ON `sys_albums`.`ID`=`sys_albums_objects`.`id_album`
WHERE 1 AND `RayVideoFiles`.`Status` ='approved' AND
CONCAT(`RayVideoFiles`.`Tags`) LIKE ('%'movie'%') AND
`sys_albums`.`Status` ='active' AND `sys_albums`.`Type` ='bx_videos'
Mysql error: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near 'movie'%') AND `sys_albums`.`Status` ='active' AND
`sys_albums`.`Type` ='bx_video' at line 1