pattern matching efficiency

[jaylee]

All of the followings work, but which of them is 'cheaper' regarding to efficiency and system resource:

1. SELECT count(*) FROM table WHERE (uri LIKE '%pagename.htm')

2. SELECT count(*) FROM table WHERE (uri = '/path/directory/pagename.htm')

3. SELECT count(*) FROM table WHERE (uri REGEXP '^/path/directory/pagename.htm\$')

[kparker]

Number 2. If you just want to compare a string for exact equality, nothing beats that for simplicity.

[jaylee]

Thank you 🙂