'2019@162440' OR field2 LIKE '%%2019@%%';
在本例中,它将尝试执行field2 = '2019@162440'和field2 LIKE '%%2019@%%'条件的匹配(即,它将搜索与这些条件匹配的行,因此,即使已经找到了行匹配的field2 = '2019@162440',也需要更多的<
我有一个名为“房间”的表名,上面有room_id和出租。mysql> select * from room;
| room_id | rental || 1mysql> select count(*),rental from room group by rental having count(*) >1;
|,我只想要一个来自租赁的</