lue%';
mysql> SELECT * FROM tbl_name WHERE FIND_IN_SET('value',set_col)>0;
-Original Message-
From: Wolfgang Schneider [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 20, 2001 4:22 AM
To: php-general
Subject: [PHP] php query for mysql table
Hi
I am a newbie to php + m
select * from yourtable where question like '%life%'
-- Original Message --
From: "Wolfgang Schneider" <[EMAIL PROTECTED]>
Reply-To: "Wolfgang Schneider" <[EMAIL PROTECTED]>
Date: Mon, 20 Aug 2001 12:22:15 +0200
>Hi
>
>I am a newbie to php + mysql and want
Lampén
-Original Message-
From: Morten Winkler Jørgensen [mailto:[EMAIL PROTECTED]]
Sent: 20. elokuuta 2001 13:47
To: [EMAIL PROTECTED]
Subject: Re[2]: [PHP] php query for mysql table
Notice that if a user enters
"life anger"
in the search field
SELECT * FROM table WHERE
Notice that if a user enters
"life anger"
in the search field
SELECT * FROM table WHERE question LIKE "%life anger%" none of the
questions
>> [1] How do you deal with anger?
>> [2] Ever been full of anger in your life?
>> [3] Is life always easy?
will match. For that you must split the query
On Mon, 20 Aug 2001 13:35:39 +0300, Niklas Lampén wrote:
>% works as a wildcard in mySQL.
>
>Example:
>
>"SELECT * FROM table WHERE Question LIKE '%life%'" would return all rows
>with field Question containing string "life".
Hello all helpers,
well ... thanks to those who have already replied a
: Wolfgang Schneider [mailto:[EMAIL PROTECTED]]
Sent: 20 August 2001 11:22
To: php-general
Subject: [PHP] php query for mysql table
Hi
I am a newbie to php + mysql and wanted to ask for some help on a
particular item which I can't seem to find "the right key" in the
documentation.
uta 2001 13:22
To: php-general
Subject: [PHP] php query for mysql table
Hi
I am a newbie to php + mysql and wanted to ask for some help on a
particular item which I can't seem to find "the right key" in the
documentation. I am trying to set up a simple Q&A system with an e
You should use the "like" clause whch allows the use of wild cards %
and ?.
Have a look at the MySQL manual, it should be explained there.
HTH
Gianluca
WS> I am a newbie to php + mysql and wanted to ask for some help on a
WS> particular item which I can't seem to find "the right key" in
Hi
I am a newbie to php + mysql and wanted to ask for some help on a
particular item which I can't seem to find "the right key" in the
documentation. I am trying to set up a simple Q&A system with an entry
page where one can select to either have all questions & answers from a
mysql database dis
9 matches
Mail list logo
