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

Popular posts from this blog

javascript - DIV "hiding" when changing dropdown value -

Does Firefox offer AppleScript support to get URL of windows? -

android - How to install packaged app on Firefox for mobile? -