simpjd Posted March 15, 2009 Share Posted March 15, 2009 Hello, I need to do the opposite to an SQL LIKE. Let me explain. In an SQL LIKE, I can find "ABCDE" by querying "ABC%" I need to find "ABC" when querying "ABCDE". [find values in database that are contained in the search query (ABCDE)] Hope this makes sense and someone can help! Jack Quote Link to comment https://forums.phpfreaks.com/topic/149520-mysql-search-opposite-to-sql-like-kind-off/ Share on other sites More sharing options...
fenway Posted March 15, 2009 Share Posted March 15, 2009 Huh? Quote Link to comment https://forums.phpfreaks.com/topic/149520-mysql-search-opposite-to-sql-like-kind-off/#findComment-785254 Share on other sites More sharing options...
Mchl Posted March 15, 2009 Share Posted March 15, 2009 So... if you search for "ABCDE", you want to find all "ABC", "BCD", "CDE", "ABCD", "BCDE" and "ABCDE"? How about "ABDE", "EDB", "BAB" ? Quote Link to comment https://forums.phpfreaks.com/topic/149520-mysql-search-opposite-to-sql-like-kind-off/#findComment-785256 Share on other sites More sharing options...
spiritgate Posted April 29, 2009 Share Posted April 29, 2009 I also want to know more about this!! Hope anyone can help Quote Link to comment https://forums.phpfreaks.com/topic/149520-mysql-search-opposite-to-sql-like-kind-off/#findComment-821511 Share on other sites More sharing options...
Mchl Posted April 29, 2009 Share Posted April 29, 2009 I also want to know more about this!! Hope anyone can help Start your own topic with your own question please. The original poster here failed to provide us any additional information. Make sure you don't make this mistake. Quote Link to comment https://forums.phpfreaks.com/topic/149520-mysql-search-opposite-to-sql-like-kind-off/#findComment-821599 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.