Does anyone know the exact query run by phpmyadmin when you goto select (click a table and choose select from the list Print view, Browse, Select, Insert).
I have been using a generic SELECT query like:
SELECT * FROM some_table WHERE name='some_name'
I noticed that in one case, phpmyadmin's select finds more results then the generic query. What is phpmyadmin doing differently?