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