php mysql多个OR语句

Question

I am trying to run a simple mysql query,but it returns nothing everytime. For some reason it seems having multiple "OR" statements is the reason. why?

returns null

mysql_query("SELECT * FROM table WHERE lower(Name)='arabic' or lower(Sub Name)='arabic' or lower(Language)='arabic'");

returns results

mysql_query("SELECT * FROM table WHERE lower(Name)='arabic'");

Answer 1

your column name has space you should surround column name with ` symbol

mysql_query("SELECT * FROM table WHERE lower(`Name`)='arabic' or lower(`Sub Name`)='arabic' or lower(`Language`)='arabic'");