List:General Discussion« Previous MessageNext Message »
From:Mike Lockhart Date:May 25 2007 5:26pm
Subject:Re: select with like not working...
View as plain text  
-----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-----
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