Re: select with like not working...

2007-05-25 Thread Ricardo Conrado Serafim
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 automat

Re: select with like not working...

2007-05-25 Thread Jason Pruim
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: SH

Re: select with like not working...

2007-05-25 Thread Mike Lockhart
-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 s

select with like not working...

2007-05-25 Thread Jason Pruim
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