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 votes124 views1 answer
Create table with primary key
SQL
0 vote122 views1 answer
Call procedure in wordpress
SQL
0 vote228 views3 answers
Osx stop mysql service
SQL
1 vote134 views1 answer
Expression number 1 of select list is not in group by clause
SQL
2 votes157 views1 answer
Oracle kill session by sql_id
SQL
1 vote136 views2 answers
Difference between in and between in sql
SQL
0 vote159 views1 answer
A network or instance-specific error sql server
SQL
1 vote157 views1 answer
Postgresql not in
SQL
0 vote122 views1 answer
QCompleter con sql
SQL
0 vote148 views1 answer
Oracle list user locked
SQL