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 vote183 views7 answers
Les jointures sql server
SQL
0 vote250 views1 answer
How to connect to xampp sql server on windows cmd
SQL
0 vote174 views1 answer
First Step in installing SQL workbench
SQL
6 votes229 views2 answers
Oracle compile trigger
SQL
0 vote200 views1 answer
Sql select random procentage from rows
SQL
0 vote180 views1 answer
Hw to delete a procedure in pl sql
SQL
1 vote172 views1 answer
Error code 1175 mysql fix
SQL
1 vote201 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
8 votes186 views6 answers
Sql insert
SQL
1 vote176 views1 answer
Substr sql last character
SQL