Thanks for helping me
If I use where...
... like '%table%'" will return anything that has 'table' is the string.
however, if i have two strings, one contains "...table...", another contains "...comfortable...", then both of these strings will be selected.
If I just want to select the one of "table" but not "comfortable",
Can anyone teach me how to do?
I'm not sure what you want.
You want to pull out any string with "table" in it, but when it does what you ask for, you don't want that?
So what is it you're looking for then?
You could try '% table %', but you would also need to back that up just in case it appears at the end of a line with '% table.%'.
also '% table,%'
using LIKE for this is just too messy, there are just too many variations that you have to cater to (all the various punctuation marks)
try this instead --
... where columname regexp '[[:<:]]table[[:>:]]'
Thanks for all your help. I appreciate it.