gazever Posted August 20, 2008 Share Posted August 20, 2008 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 Link to comment https://forums.phpfreaks.com/topic/120527-solved-sql-select-with-exact-character-matching-using-wildcard/ Share on other sites More sharing options...
php_dave Posted August 20, 2008 Share Posted August 20, 2008 Hi Gazever, Have you tried the single character wildcard? like 'd_t_' Havent tested but I think that would work. Link to comment https://forums.phpfreaks.com/topic/120527-solved-sql-select-with-exact-character-matching-using-wildcard/#findComment-621080 Share on other sites More sharing options...
gazever Posted August 20, 2008 Author Share Posted August 20, 2008 Works a treat, Thanks so much Link to comment https://forums.phpfreaks.com/topic/120527-solved-sql-select-with-exact-character-matching-using-wildcard/#findComment-621088 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.