php - MySQL exact word existence check in a table Field -
i've query. there built-in function or other method associated mysql, return rows contains exact word in database table field? i'm aware mysql operator, can search specified pattern in column match string value against pattern string containing wild-card characters. mysql clause, it'll return substring entries too.
eg.
suppose 3 column values below:
1. "take shot of courage" 2. "the end of age not yet" 3. "employers can obtain wage rate submitting request"
i want retrieve rows in column value contains exact word 'age'
if prepare query
select * sometable somefield '%age%'
it'll return 3 rows. intention second row. how achieve this? in advance.
cheers,
jenson.
use query
select * sometable somefield '% age %' or somefield 'age %' or somefield '% age'
Comments
Post a Comment