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 vote432 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote352 views1 answer
Oracle query archive mode
SQL
10 votes352 views2 answers
Rtrim sql
SQL
0 vote312 views2 answers
Sql select inside select
SQL
1 vote323 views2 answers
Sql convert datetime to year month
SQL
0 vote340 views1 answer
Datagrip go to line
SQL
0 vote391 views1 answer
How to find unique element in sql
SQL
0 vote342 views1 answer
Create schema sql server
SQL
0 vote354 views1 answer
Uncheck constraints and delete from table
SQL
38 votes435 views6 answers
Ubuntu install mysql client
SQL