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
>>> 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)
>> -----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