I'm using phpMyAdmin and trying to create a very simple view.
Following is the SQL as I "save" it:
Code: Select all
SELECT UserSites_Tbl.User_ID AS SiteUser
FROM UserSites_Tbl
WHERE (((UserSites_Tbl.SiteName)="MySite") AND ((UserSites_Tbl.UserCategory) Like "Org%"))Code: Select all
SELECT`UserSites_Tbl`.`User_ID` AS `SiteUser`
FROM`UserSites_Tbl`
WHERE ((`UserSites_Tbl`.`SiteName` = 'MySite') and (`UserSites_Tbl`.`UserCategory` like '\0\0\0O\0\0\0r\0\0\0g\0\0\0%'))Does anyone have any ideas as to how I can save the view without it corrupting the Like "Org%" to like '\0\0\0O\0\0\0r\0\0\0g\0\0\0%'?
Thanks in advance -
Pavilion