-----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: [EMAIL PROTECTED] ======================================== -----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/[EMAIL PROTECTED]
