[SOLVED] sql select with exact character matching using wildcard

[gazever]

I am building a databse of crossword words.

 

I want to select where word = d?t?

 

I am trying to use select where word like 'd%t%'

 

however when running it I expect to get returned results of the word

 

DATA

 

but it seems to search where d & t are in that order returning for example

 

ADIT, DART

 

etc

 

do I have to get all these results then match character for character through an array or can I do this in my mysql query

 

Many Thanks

 

Gazever

[php_dave]

Hi Gazever,

 

Have you tried the single character wildcard?

 

like 'd_t_'

 

Havent tested but I think that would work.

[gazever]

Works a treat,

 

Thanks so much