erikjan Posted May 1, 2007 Share Posted May 1, 2007 Can someone please help. Thanks! In SELECT you can use LIKE. UNLIKE does not exist, but I would like to retrieve the following data from the database. $sql="SELECT * FROM objects WHERE object_rubric='1' AND object_artist_name LIKE 'd%' AND object_xx UNLIKE 'blabla%' AND (object_date_sold='0' OR object_sold_stay='1') ORDER BY object_artist_name ASC LIMIT $from, $max_results"; Which syntax can I use instead of UNLIKE ?? Thanks in advance!! Link to comment https://forums.phpfreaks.com/topic/49461-solved-unlike-vs-like/ Share on other sites More sharing options...
trq Posted May 1, 2007 Share Posted May 1, 2007 NOT LIKE Link to comment https://forums.phpfreaks.com/topic/49461-solved-unlike-vs-like/#findComment-242450 Share on other sites More sharing options...
Wildbug Posted May 1, 2007 Share Posted May 1, 2007 It's funny that wasn't in the manual. Link to comment https://forums.phpfreaks.com/topic/49461-solved-unlike-vs-like/#findComment-242485 Share on other sites More sharing options...
trq Posted May 1, 2007 Share Posted May 1, 2007 It's funny that wasn't in the manual. Yes it is. Right here. Link to comment https://forums.phpfreaks.com/topic/49461-solved-unlike-vs-like/#findComment-242525 Share on other sites More sharing options...
Wildbug Posted May 1, 2007 Share Posted May 1, 2007 Link to comment https://forums.phpfreaks.com/topic/49461-solved-unlike-vs-like/#findComment-242533 Share on other sites More sharing options...
erikjan Posted May 1, 2007 Author Share Posted May 1, 2007 Thx for the answer! Link to comment https://forums.phpfreaks.com/topic/49461-solved-unlike-vs-like/#findComment-242606 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.