: mysql; asus77x
Subject: Re: select command
You should not contact people on the MySQL list offline; all communication
should be via the list so that everyone can benefit from the discussion.
As I said earlier, your WHERE clause does not make sense the way you
expressed it in your first email. I
uestion.
Thanks.
-Original Message-
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 24, 2005 10:05 PM
To: asus77x; mysql@lists.mysql.com
Subject: Re: select command
I have a command :
SELECT * FROM reg_one WHERE 'varName' like 'varTmp' %
This is made wi
Hello.
> Becomes to like varName or varTmp ?
Sorry, but I'm not completely understanding your question
(may be because I'm not familiar with dreamweaver). What
does it mean 'like varName or varTmp'? Do you want to change
the name from reg_one to var_one? Or you want to be able
dynamically
- Original Message -
From: "asus77x" <[EMAIL PROTECTED]>
To:
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 statemen
Thank you,
That did the trick.
> -Original Message-
> From: Egor Egorov [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 27, 2004 12:17 AM
> To: [EMAIL PROTECTED]
> Subject: Re: select command with a search?
>
> "Christopher Lyon" <[EMAIL PROTECTED
> I want to be able to search for specific text in a field and return the
> results for those rows. What is the best way to go about it? Do I use
> the regex stuff or match?
You can use
- ...WHERE column LIKE '%specific text%'
- "use the regex stuff" (which is mostly slower than LIKE)
- MATCH afte
"Christopher Lyon" <[EMAIL PROTECTED]> wrote:
> I want to be able to search for specific text in a field and return the
> results for those rows. What is the best way to go about it? Do I use
> the regex stuff or match?
>
It depends.
You can use LIKE, REGEXP, full-text search for those purpose:
