MySQL - finding the exact word from a string

Question

I want to find the exact word from a string, for example

id  Description
1   This is nice pen looking good
2   This is nice pendrive looking good

Search string :pen

My current request

SELECT * FROM `table` WHERE Description like '%pen%';

Above the query, return both records, but I want only the first record. Because the word pen exactly matches my search bar.

Expected Result

1   This is nice pen looking good

Demo

Answer 1

Try using regular expressions:

SELECT 
    *
FROM
    `table`
WHERE
    Description regexp '(^|[[:space:]])pen([[:space:]]|$)';

Demo

Or using word boundaries :

SELECT 
    *
FROM
    `table`
WHERE
    Description regexp '[[:<:]]pen[[:>:]]';

Answer 2

You can use REGEXPboth [[:<:]]and [[:>:]]word boundary labels:

SELECT
    *
FROM
    `table`
WHERE
    Description REGEXP '[[:<:]]pen[[:>:]]';

SQL Fiddle Demo

Answer 3

,

$query="SELECT * FROM table_name WHERE MATCH (column_name) AGAINST 
  ('search_word' IN NATURAL LANGUAGE MODE)" ;

,

Answer 4

,

SELECT * FROM 'table' WHERE Description ='pen';