Member Avatar for flashyflashy
flashyflashy 0 Newbie Poster 
EXPLAIN SELECT post
FROM `table`
WHERE id = '123' 
LIMIT 1

There are 411 records in table for id=123, even though limit of 1 is forced in the syntax, explain syntax shows that there are 411 rows in the table for the above query.

Does that mean mysql will search all 411 rows even though it only displays 1 row.

BTW id is an index.

Edited by flashyflashy because: n/a
  • 1 Contributor
  • 0 Replies
  • 52 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.