data in myTable
(ID) say
(1) He is a doctor.
(2) Is he a doctor?
(3) You are doctor.
I have the above data in myTable.
[b] code[/b]
select ID, say
from myTable
where say regexp 'he' and say regexp 'is'
[b]result[/b]
(1) He is a doctor.
(2) Is he a doctor?
The above retrieved two records.
My target result is in the below.
[b] target result[/b]
(1) He is a doctor.
I like to retrieve only record(1) because the first key "he" comes first in record(1) while the second key "is" come first in record(2).
Thanks in Advance
