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: [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]
--
Ricardo Conrado Serafim
DBA JĂșnior (MySQL)
URANET - www.uranet.com.br
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]