List:General Discussion« Previous MessageNext Message »
From:Rhino Date:November 24 2005 3:04pm
Subject:Re: select command
View as plain text  
----- Original Message ----- 
From: "asus77x" <asus77x@stripped>
To: <mysql@stripped>
Sent: Thursday, November 24, 2005 2:07 AM
Subject: select command


>I have a command :
>
> SELECT * FROM reg_one WHERE 'varName' like 'varTmp' %
>
> This is made within dreamweaver mx.
>
I think there must be a typo in the statement you have provided. This syntax 
is not correct; the % symbol should be inside the single quotes, not 
following them. Also, you normally don't have two strings in the same WHERE 
condition.  Perhaps you mean this, or something like it?

SELECT * FROM reg_one where varName like 'varTmp%'

> varName and varTmp is a textselect.
> Does anyone can help how to make "reg_one"
> Becomes to like varName or varTmp ?
>
I'm sorry but I'm not sure if I understand your question, it sounds as if 
English is not your best language :-) Are you saying that you want the table 
name to be a variable in your query?

Rhino 



-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.7/181 - Release Date: 24/11/2005

Thread
LEFT JOIN not working on 5.0.16 - urgent helpTerence24 Nov
  • Re: LEFT JOIN not working on 5.0.16 - urgent helpSimon Garner24 Nov
  • Re: LEFT JOIN not working on 5.0.16 - urgent helpPeter Brawley24 Nov
  • Re: LEFT JOIN not working on 5.0.16 - urgent helpSGreen24 Nov
    • select commandasus77x24 Nov
      • Re: select commandRhino24 Nov
      • Re: select commandGleb Paharenko24 Nov
Re: select commandRhino25 Nov
  • RE: select commandasus77x25 Nov