----- Original Message -----
From: "asus77x" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
