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\$')
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\$')