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 vote366 views1 answer
Hoq to import database source
SQL
2 votes362 views1 answer
Query to find table size in oracle 12c
SQL
1 vote351 views1 answer
Postgresql delete cascade
SQL
2 votes375 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote365 views1 answer
Mysql add text to existing field
SQL
4 votes420 views2 answers
Sql display today's date
SQL
1 vote340 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote337 views1 answer
Psql check if value in array
SQL
2 votes369 views2 answers
Postgres trigger insert into another table
SQL
2 votes345 views1 answer
Create table with primary key
SQL