At 3:12 +0200 10/8/04, Przemyslaw Popielarski wrote:
User variables do not work with REGEXP under MySQL 4.0.21 & 4.1.5.
Is this a bug or a feature?
It's difficult to provide an answer to this because you're providing
no information about what "do not work" means. Can you be more specific?
mysql> set @x = 'abc';
Query OK, 0 rows affected (0.13 sec)
mysql> select @x like 'a%';
+--------------+
| @x like 'a%' |
+--------------+
| 1 |
+--------------+
1 row in set (0.08 sec)
mysql> select @x like 'b%';
+--------------+
| @x like 'b%' |
+--------------+
| 0 |
+--------------+
1 row in set (0.01 sec)
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
