Match string in SQL?
#5
When I was using LIKE it was matching similar strings!

This one seems to work!

$search = "this-is-a-test-title";

$query = $db->query("
        SELECT a.id, a.url
        FROM ".TABLE_PREFIX."ads a
	WHERE a.url IN ('".$search."')
    ");
	
	
			while($row = $db->fetch_array($query))
			{
				
		echo $row['id'];

			}


Looks like it checks if it's 100% not like similar. Am I right?
Reply


Messages In This Thread
Match string in SQL? - by marcus123 - 2015-06-19, 04:21 PM
RE: Match string in SQL? - by martec - 2015-06-19, 04:36 PM
RE: Match string in SQL? - by marcus123 - 2015-06-19, 06:15 PM
RE: Match string in SQL? - by Destroy666 - 2015-06-21, 01:52 AM
RE: Match string in SQL? - by marcus123 - 2015-06-22, 10:49 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)