Simple SQL query (if you know much about SQL anyway)

[johnsmith153]

I believe this is standard for SQL queries:

$sql = sprintf("SELECT Name FROM $tableName WHERE Name LIKE '%s'",mysql_real_escape_string($name));

 

However, I want to do this:

$sql = "SELECT Name FROM $tableName WHERE Name LIKE '%$name%'";

i.e I want to search the table and return values that contain the $name (as opposed to the first one which only returns exact matches).

 

 

How would I do the sprintf code that also includes the ability to search part of a value (ie the % before and after the value)?

[wildteen88]

$sql = sprintf("SELECT Name FROM %s WHERE Name LIKE '%%%s%%'", $tableName, mysql_real_escape_string($name));