List:General Discussion« Previous MessageNext Message »
From:Richard Bensley Date:May 11 2011 7:33pm
Subject:Re: Using @ variables with LIKE,CONCAT
View as plain text  
Hi, I just tried this on a schema I had laying about and it worked fine:

mysql> SET @dude='pilgrim';
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT namefield FROM mytable WHERE namefield LIKE
CONCAT('%',@dude,'%');
+-----------------------------------------------+
| name                                          |
+-----------------------------------------------+
| Blood Elf Pilgrim                             |
| Blood Elf Pilgrim                             |
| Draenei Pilgrim                               |
| High Elf Pilgrim                              |
| Pilgrim Gal'ressa                             |
| Recovering Pilgrim                            |
| Wounded Blood Elf Pilgrim                     |
| Young Pilgrim                                 |
+-----------------------------------------------+

I am running 5.5.6 x64 on Mac OS X.

Rich


On 11 May 2011 20:03, Hank <heskin@stripped> wrote:

> This used to work fine in Mysql 4.3, but no longer works in 5.5.8:
>
> set @txt='needle';
> select * from table where field  like CONCAT('%',@txt,'%');
>
> --returns the null set.  If I substitute like this:
>
> select * from table where field  like '%needle%';
>
> it works perfectly (and as it did in 4.x).
>
> How can I get this to work in 5.5.x?
>
> Thanks,
>
> -Hank
>



-- 
*Richard Bensley*
*Database Administrator*
*
*
richard.bensley@stripped
skype: richardbensley
Mobile: 07540878285

Thread
Using @ variables with LIKE,CONCATHank11 May
  • Re: Using @ variables with LIKE,CONCATRichard Bensley11 May