SELECT where row value contains string MySQL

Question

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

User · Answer

This should work   SELECT   FROM Accounts WHERE Username LIKE    query

User · Answer

Use the   wildcard  which matches any number of characters   SELECT   FROM Accounts WHERE Username LIKE   query

User · Answer

SELECT   FROM Accounts WHERE Username LIKE    query     but it s not suggested  use PDO

User · Answer

My suggestion would be   value     POST  myfield      Query   Database  Prepare  SELECT   FROM TABLE WHERE MYFIELD LIKE       Query- gt Execute array      value

[php] SELECT where row value contains string MySQL

Examples related to php

Examples related to mysql