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 vote104 views1 answer
Database xml sql
SQL
3 votes118 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
1 vote120 views2 answers
Mysql limit offset
SQL
0 vote104 views1 answer
Sql server check whether column has same equal values
SQL
15 votes115 views5 answers
Show tables in oracle
SQL
0 vote116 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
0 vote125 views1 answer
Sql output select
SQL
13 votes140 views3 answers
List all the tables in sql
SQL
0 vote122 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
0 vote110 views1 answer
Conda install pymysql "windows"
SQL