phpMyAdmin View Question
Posted: Wed Nov 14, 2012 9:10 am
Hello - I hope I'm posting this question in the correct place.
I'm using phpMyAdmin and trying to create a very simple view.
Following is the SQL as I "save" it:
When I execute the above syntax it works just fine, and returns the records I expect it to return. However... once I save the above syntax as a VIEW, the VIEW returns 0 records. Upon further research, I've found that the above syntax saves as follows:
No matter what I do when "saving" my original syntax, it actually "saves" as the second snippet (hence a result of 0 records).
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
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