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

6 votes174 views3 answers
Update with inner join postgres
SQL
1 vote180 views1 answer
Pl sql create table from another table
SQL
0 vote188 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
3 votes171 views3 answers
Create a view postgres
SQL
1 vote199 views1 answer
Oracle list data files
SQL
1 vote158 views4 answers
Between vs in sql
SQL
0 vote166 views1 answer
Downgrading sql localdb visual studio
SQL
0 vote226 views1 answer
Sqlite trim
SQL
0 vote232 views1 answer
Mariadb used space
SQL
1 vote173 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL