Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: prasanna kunder
  Where is prasanna kunder?
 mumbai
 India
 prasanna kunder
 To: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 Tags
Subject: RE: mysql query error
Thread ID: 393696 Message ID: 393799 # Views: 28 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Monday, December 23, 2013 7:34:45 PM         
   


> > hello experts
> >
> > not showing all records staring from namevar = "K"
> >
> >
> > lSearch = "Select * from Student Where name= ?namevar"
> >
> > it's not showing records, my table have 10 records starting from alphabet 'K'
> >
> > what i am missing
> >
> > thanks in advance
> >
> > edited

> >
> > OK GOT IT in mysql but how to use in vfp
> >
> > SELECT * FROM `atharva_data`.`student` where Ssname LIKE '%K%' ;
> >
> > is' there any other way
>
> .. WHERE name LIKE 'K%'
> begins with K
> .. name LIKE '%K%
> contains a K, anywhere.
> .. name LIKE %K'
> ends with K
> .. name LIKE 'K'
> exactly like 'K', nothing more.
>
> SQL standard for string comparisons. Works perfectly well in VFP. LIKE 'K%' and LIKE 'K' are optimizable in VFP.
>
> -Anders

thanks

ENTIRE THREAD

mysql query error Posted by prasanna kunder @ 12/22/2013 2:18:17 AM
RE: mysql query error Posted by David Mustakim @ 12/22/2013 3:05:14 AM
RE: mysql query error Posted by Vivek Deodhar @ 12/22/2013 9:15:39 AM
RE: mysql query error Posted by prasanna kunder @ 12/23/2013 7:35:38 PM
RE: mysql query error Posted by Anders Altberg @ 12/22/2013 11:55:46 AM
RE: mysql query error Posted by prasanna kunder @ 12/23/2013 7:34:45 PM