[b]data in myTable[/b]
(1) I [b][COLOR=Blue]a[/COLOR][/b]m [b][COLOR=Blue]a[/COLOR][/b] boy
(2) [b][COLOR=Blue]A[/COLOR][/b]re you m[COLOR=Red]a[/COLOR]king fun of him?
(3) Yes, I [b][COLOR=Blue]a[/COLOR][/b]m
(4) He h[COLOR=Red]a[/COLOR]s m[COLOR=Red]a[/COLOR]ny books
(5) She is [b][COLOR=Blue]a[/COLOR][/b] girl
(6) I [b][COLOR=Blue]a[/COLOR][/b]m going to h[COLOR=Red]a[/COLOR]ve a b[COLOR=Red]a[/COLOR]by
(7) He is good.
I like to retrieves (2), (4) and (6).
The following is one of my trials.
[b]trial code[/b]
where say like '%a%'
and say not like 'a%'
and say not like '%a'
and say not like '% a%'
and say not like '%a %'
[b]result[/b]
(4) He h[COLOR=Red]a[/COLOR]s many books
But the trial code above retrieves only (4).
[b]solution[/b]
where
say regexp '[[:<:]]([[:alnum:]])+a([[:alnum:]])+[[:>:]]'
The above is a solution for getting my target result, and it works fine.
But I like to not use "regExp" for my own reason.
How can I retrieve (2), (4) and (6) without using regExp?
Is this impossible?
Thanks in Advance
