List:General Discussion« Previous MessageNext Message »
From:Ricardo Conrado Serafim Date:May 25 2007 7:38pm
Subject:Re: select with like not working...
View as plain text  
would you can post the table script?? create and insert...
because it should be work ...

Jason Pruim escreveu:
> I have tried %jason%, %jason, & jason% all with the same result... Do 
> you need to have an index of the column? Currently I didn't 
> intentionally make one so I'm not sure if it's automatic or not...
>
>
> On May 25, 2007, at 1:26 PM, Mike Lockhart wrote:
>
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> Have you tried using 'jason%' instead of '%jason%'?  Also, do you have
>> an index on that column?
>>
>> Jason Pruim wrote:
>>> Hi all,
>>>
>>> I'm new to the list so please excuse me if I make some newbie mistakes,
>>> I am having trouble figuring out why a select statement won't work,
>>> Here's the statement: "SELECT 'FName' FROM `current` WHERE `FName` like
>>> '%jason%';".
>>>
>>> if I run select 'FName' FROM current; then I get 6 rows that say
>>> 'jason'. but nothing is showing up when I use 'like'.
>>>
>>> Any ideas?
>>>
>>> Thanks for looking!
>>>
>>>
>>
>>
>> - --
>> ========================================
>> Mike Lockhart      Information Engineer
>> ChoiceMed, Inc
>> Email:  mlockhart@stripped
>> ========================================
>> -----BEGIN PGP SIGNATURE-----
>> Version: GnuPG v1.4.7 (Darwin)
>>
>> iD8DBQFGVxxcgCgDHkdt5m8RAqTOAKCAdoL4JSjUzsKG1Y9/wdcTCeSdswCffwOy
>> YO0ALUVivjv7ZDFfXUAbn1M=
>> =J52W
>> -----END PGP SIGNATURE-----
>>
>> -- 
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>>
>>
>
>


-- 
Ricardo Conrado Serafim
DBA Júnior (MySQL)
URANET - www.uranet.com.br

Thread
select with like not working...Jason Pruim25 May
  • Re: select with like not working...Mike Lockhart25 May
    • Re: select with like not working...Jason Pruim25 May
      • Re: select with like not working...Ricardo Conrado Serafim25 May