pattern matching efficiency

admin

Administrator
Staff member
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\$')
 
Back
Top