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 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? 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" ? 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 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. 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
Archived
This topic is now archived and is closed to further replies.