Ok, I'm seeing really odd stuff with queries for a simple result set. Can anyone explain why the following is happening and HOW I can fix it?
mysql> select DrugName from ms_drugs where DrugName like 'tylenol%' order by DrugName LIMIT 1,20;
+------------+
| DrugName |
+------------+
| Tylenol #3 |
+------------+
1 row in set (0.01 sec)
mysql> select DrugName from ms_drugs where DrugName like 'tylenol%';
+------------+
| DrugName |
+------------+
| Tylenol #3 |
| Tylenol |
+------------+
2 rows in set (0.01 sec)
Start Free Trial