Writing SQL query for a given combination of letters -
i want write sql query wherein fourth letter should 'x'
, there should 'm'
anywhere in whole word. having list of on 5000 words.
i tried command
where name '___x%m%'
but give me x
fourth letter , there m after x, how find names have x
fourth letter , have m
coming before x
?
you can this:
where name '____x%' , name '%m%'
Comments
Post a Comment