我想查询符合 field1 或者field2 或者field3 里有文字books,并且field4 或者field5 或者field6 里有文字english,结果按照时间倒序,限制条数为30。
我使用PHP
这样的 MYSQL QUERY语句正确吗?求一个效率高一点的语句。谢谢
table:
id | date | field1 | field2 | field3 | field4 | field5 | field6
1 | 1298617011 | textbook | newspaper | | chinese | Japanese | english
2 | 1298618005 | books | | | chinese | french | field1
3 | 1298618083 | newspaper| magazine | books | english | | ...
$result = mysql_query("SELECT * FROM table WHERE (field1 = 'books' OR field2 = 'books'OR field3 = 'books') and (field4 = 'english' OR field5 = 'english' OR field6 = 'english') Order By date DESC LIMIT 30");
我使用PHP
这样的 MYSQL QUERY语句正确吗?求一个效率高一点的语句。谢谢
table:
id | date | field1 | field2 | field3 | field4 | field5 | field6
1 | 1298617011 | textbook | newspaper | | chinese | Japanese | english
2 | 1298618005 | books | | | chinese | french | field1
3 | 1298618083 | newspaper| magazine | books | english | | ...
$result = mysql_query("SELECT * FROM table WHERE (field1 = 'books' OR field2 = 'books'OR field3 = 'books') and (field4 = 'english' OR field5 = 'english' OR field6 = 'english') Order By date DESC LIMIT 30");
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货