Hello y'all,
I guess this is easy, but it is defeating me.
I am having a problem with this query:
$keyword = search;
SELECT * FROM table WHERE field LIKE '%$keyword%'
The problem is I don't want sear or earch but exactly search.
What am I missing?
..
Regards, Robert (Newbie)
Robert Macwange wrote:
Hello y'all,
I guess this is easy, but it is defeating me.
I am having a problem with this query:
$keyword = search;
SELECT * FROM table WHERE field LIKE '%$keyword%'
Hint, for 'search' in middle of phrase:
SELECT * FROM table WHERE field LIKE '% $keyword %'
: Wednesday, August 21, 2002 4:18 PM
Subject: Exact word search
Hello y'all,
I guess this is easy, but it is defeating me.
I am having a problem with this query:
$keyword = search;
SELECT * FROM table WHERE field LIKE '%$keyword%'
The problem is I don't want sear or earch but exactly search
Use FullText indexing or a REGEXP.
Brian.
- Original Message -
From: Robert Macwange [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 21, 2002 9:18 AM
Subject: Exact word search
| Hello y'all,
|
| I guess this is easy, but it is defeating me.
| I am having a problem
Hello y'all,
I guess this is easy, but it is defeating me.
I am having a problem with this query:
$keyword = search;
SELECT * FROM table WHERE field LIKE '%$keyword%'
The problem is I don't want sear or earch but exactly search.
like % $keyword %;
]
Sent: Wednesday, August 21, 2002 10:18 AM
Subject: Exact word search
Hello y'all,
I guess this is easy, but it is defeating me.
I am having a problem with this query:
$keyword = search;
SELECT * FROM table WHERE field LIKE '%$keyword%'
The problem is I don't want sear or earch but exactly
On 21 Aug 2002, at 16:27, tibyke wrote:
$keyword = search;
SELECT * FROM table WHERE field LIKE '%$keyword%'
The problem is I don't want sear or earch but exactly search.
like % $keyword %;
But that won't find search if it's at the beginning or end of a
string, or preceded or
I guess this is easy, but it is defeating me.
I am having a problem with this query:
$keyword = search;
SELECT * FROM table WHERE field LIKE '%$keyword%'
The problem is I don't want sear or earch but exactly search.
If you're looking for an exact match, where field will contain NOTHING