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

2 votes246 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote253 views2 answers
Auto increment column in mysql query results
SQL
0 vote256 views1 answer
Mysql create pool
SQL
0 vote254 views1 answer
Mysql check datetime equals date
SQL
6 votes245 views1 answer
Postgresql get year
SQL
3 votes246 views1 answer
Oracle apex warning message
SQL
0 vote255 views1 answer
Sql getdate minus 1 day without time
SQL
0 vote261 views1 answer
Sql query to get contact form 7 fields
SQL
3 votes255 views2 answers
Postgresql remove not null constraint
SQL
20 votes266 views3 answers
Update values in select statement sql
SQL