How can I select a row in my MySQL DB where the value of a column contains 'XcodeDev' for example?
I tried:
SELECT * FROM Accounts WHERE Username LIKE '$query'
But it only selects a row were the Username value is exactly the same to the query.
What can I do to achieve what I want?
SELECT * FROM Accounts WHERE Username LIKE '%$query%'
but it's not suggested. use PDO
My suggestion would be
$value = $_POST["myfield"];
$Query = Database::Prepare("SELECT * FROM TABLE WHERE MYFIELD LIKE ?");
$Query->Execute(array("%".$value."%"));
This should work:
SELECT * FROM Accounts WHERE Username LIKE '%$query%'
Source: Stackoverflow.com