Code:
select distinct(code) from school where type='main'
return 0 row
but there are many rows where type column has value main
-
where type is column
return 0 row
but there are many rows where type column has value main -
Are you sure there are no spaces, or other trash-characters, surrounding either you search keyword or the data in the database. (You can use trim() to remove such characters from your variables)
What exactly is the code field?
Could you show us a the data you have in your database? (A couple of rows would be fine.) -
In answer to your question... 'type' is not a keyword (Reserved Word).
Comment
Comment