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 Quote 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. Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.