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 vote224 views1 answer
Sql select sum group by id laravel join
SQL
9 votes232 views5 answers
Sql delete duplicate rows but keep one
SQL
3 votes207 views1 answer
Oracle get trigger ddl
SQL
2 votes228 views3 answers
Current setting postgres timezone
SQL
7 votes203 views1 answer
Append column sql
SQL
2 votes175 views1 answer
Oracle sql drop column if exists
SQL
0 vote209 views1 answer
Dapper run sql script with parameters
SQL
1 vote210 views1 answer
Postgres get month name from date
SQL
3 votes214 views2 answers
Create schema postgres
SQL
8 votes242 views2 answers
Replace string value in sql
SQL