Hi,
PeterG,
Could you please comment this bug and the bug #746.
Thank you in advance.
Date: 28 Jun 2003 13:44:25 -0000
To: dev-...@mysql.com
Subject: #747 [NEW]: using an index on some regular expressions
From: Bug Database <dev-...@mysql.com>
<cut>
From: Daniel Penning
Priority: Low
Status: Open
Severity: Feature request
Category: Server
Reported by: User
Reported at:
Email subject:
Email date:
Release:
Operating system:
Bug description: using an index on some regular expressions
Description:
regular expressions starting with constant characters and those starting
with a small character range (e.g. [a-d].*) should be able to use an index
to speed up the search.
while this performance improvement is not implemented a workarround should
be mentionend into the documentation:
SELECT * FROM foo WHERE bar RLIKE 't[aeiou].*'
should be changed to
SELECT * FROM foo WHERE bar LIKE 't%' AND bar RLIKE 't[aeiou].*'
How to repeat:
-
Suggested fix:
<cut>
For technical support contracts, visit https://order.mysql.com/
Are you MySQL certified?, http://www.mysql.com/certification/
2 messages in com.mysql.lists.bugsFwd: #747 [NEW]: using an index on so...