Mysql does sentence contain word

#select rows where myColumn has the actualy word (not just the string)
#ie: the word has a space on one side of it
SELECT * FROM myTable WHERE myColumn  
like 'myWord' 
or myColumn like  'myWord %'
or myColumn like '% myWord'
or myColumn like '% myWord %';

Mysql does sentence contain word

SELECT *
FROM myTable 
WHERE myColumn REGEXP '[[:<:]]myword[[:>:]]'

Similar codes

0 vote233 views2 answers
Android sqlite query join
SQL
4 votes225 views1 answer
Select nls_date_format
SQL
1 vote236 views1 answer
Alphabetical order mysql
SQL
0 vote210 views1 answer
Mysql sleep connections
SQL
31 votes245 views2 answers
Grant all priviledges to mysql user
SQL
0 vote236 views1 answer
Sql server information_schema temp tables
SQL
0 vote241 views1 answer
Datetime postgres typeorm
SQL
2 votes247 views2 answers
Sqlalchemy filter or
SQL
50 votes261 views6 answers
Install mysql on ubuntu
SQL
0 vote230 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL