Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 To: prasanna kunder
  Where is prasanna kunder?
 mumbai
 India
 prasanna kunder
 Tags
Subject: RE: mysql query error
Thread ID: 393696 Message ID: 393705 # Views: 38 # Ratings: 1
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Sunday, December 22, 2013 11:55:46 AM         
   


> 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

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