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 %'
but you are really looking for REGEXP mysql function.....
>
> The problem is I don't want "sear" or earch but exactly "search".
>
> What am I missing?
>
> ..........
> Regards, Robert (Newbie)
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
--
Deem0N ** [EMAIL PROTECTED] **
Natural born YASPer http://www.yasp.com/
Just Another Perl Monger http://spb.pm.org/
R U X Y founder http://www.ruxy.org.ru/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
